RodrigoDW
23/02/2016, 08:35 PM
olá meus amigos, então estou com um problema que não consigo resolver troquei de Servidor Dedicado instalei um SQL SERVER 2008 R2 do zero novamente porem tenho alguns problemas, ao rodar querys pesquisei a minha duvida no site da Microsoft porem não entendi nada. Se alguem tiver como me auxiliar ou como resolver tal problema definitivamente.
Sempre que vou rodar uma Query da o seguinte erro Msg 2714, Level 16, State 6, Line 1 confusedbusquei a solução na Microsoft vou da um exemplo de uma query que tento rodar e como a microsfot diz que seria a forma correta quando tal erro é apresentado. Desde já obrigado !
Minha Query " A MESMA É DO SITE QUE O iFreeHP postou junto ao template para o MuSite 2.5
USE [webSite]
GO
/****** Object: Table [dbo].[webScreenshots] Script Date: 08/17/2010 17:56:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webScreenshots](
[id] [int] IDENTITY(1,1) NOT NULL,
[image] [varchar](50) NOT NULL,
[uploadBy] [varchar](10) NOT NULL,
[date] [int] NOT NULL,
[rate] [tinyint] NOT NULL,
[legend] [varchar](50) NOT NULL,
[sw] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_sw] DEFAULT ((0)),
[sy] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_sy] DEFAULT ((0)),
[cw] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_cw] DEFAULT ((0)),
[cy] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_cy] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Solução encontrada no site da Microsoft porém não entendi
USE DatabaseName
GO
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
Sempre que vou rodar uma Query da o seguinte erro Msg 2714, Level 16, State 6, Line 1 confusedbusquei a solução na Microsoft vou da um exemplo de uma query que tento rodar e como a microsfot diz que seria a forma correta quando tal erro é apresentado. Desde já obrigado !
Minha Query " A MESMA É DO SITE QUE O iFreeHP postou junto ao template para o MuSite 2.5
USE [webSite]
GO
/****** Object: Table [dbo].[webScreenshots] Script Date: 08/17/2010 17:56:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webScreenshots](
[id] [int] IDENTITY(1,1) NOT NULL,
[image] [varchar](50) NOT NULL,
[uploadBy] [varchar](10) NOT NULL,
[date] [int] NOT NULL,
[rate] [tinyint] NOT NULL,
[legend] [varchar](50) NOT NULL,
[sw] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_sw] DEFAULT ((0)),
[sy] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_sy] DEFAULT ((0)),
[cw] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_cw] DEFAULT ((0)),
[cy] [smallint] NOT NULL CONSTRAINT [DF_webScreenshots_cy] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Solução encontrada no site da Microsoft porém não entendi
USE DatabaseName
GO
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END