【大乌龟】sqlcommand调用问题？

[zxcw12sadzxc]

GO
/****** 对象:  Table [dbo].[DayList]    脚本日期: 11/22/2010 11:47:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DayList](
	[Datecode] [varchar](10) NOT NULL,
	[ItemID] [varchar](32) NOT NULL,
	[ItemUrl] [varchar](200) NOT NULL,
	[PV] [int] NOT NULL,
	[UV] [int] NOT NULL,
	[ItemTitle] [varchar](200) NOT NULL,
	[PicUrl] [varchar](200) NOT NULL,
 CONSTRAINT [PK_DAYLIST] PRIMARY KEY CLUSTERED 
(
	[Datecode] ASC,
	[ItemUrl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[MonthList]    脚本日期: 11/22/2010 11:47:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MonthList](
	[Datecode] [varchar](10) NOT NULL,
	[ItemID] [varchar](32) NOT NULL,
	[ItemUrl] [varchar](200) NOT NULL,
	[PV] [int] NOT NULL,
	[UV] [int] NOT NULL,
	[ItemTitle] [varchar](200) NOT NULL,
	[PicUrl] [varchar](200) NOT NULL,
 CONSTRAINT [PK_MonthList_1] PRIMARY KEY CLUSTERED 
(
	[Datecode] ASC,
	[ItemUrl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[intoList]    脚本日期: 11/22/2010 11:47:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[intoList](
	[UserName] [varchar](32) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[PageList]    脚本日期: 11/22/2010 11:47:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PageList](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](32) NOT NULL,
	[CurrentPage] [varchar](200) NOT NULL,
	[OS] [varchar](50) NOT NULL,
	[Browser] [varchar](50) NOT NULL,
	[sVisitors] [varchar](50) NOT NULL,
	[UserIP] [varchar](50) NOT NULL,
	[sLanguage] [varchar](50) NOT NULL,
	[RefPage] [varchar](200) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_PageList] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[YearList]    脚本日期: 11/22/2010 11:48:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[YearList](
	[Datecode] [varchar](10) NOT NULL,
	[ItemID] [varchar](32) NOT NULL,
	[ItemUrl] [varchar](200) NOT NULL,
	[PV] [int] NOT NULL,
	[UV] [int] NOT NULL,
	[ItemTitle] [varchar](200) NOT NULL,
	[PicUrl] [varchar](200) NOT NULL,
 CONSTRAINT [PK_YearList] PRIMARY KEY CLUSTERED 
(
	[Datecode] ASC,
	[ItemUrl] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[StopList]    脚本日期: 11/22/2010 11:48:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[StopList](
	[StopID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](32) NULL,
	[CreateDate] [datetime] NULL,
	[StopPage] [varchar](200) NOT NULL,
	[ItemUrl] [varchar](200) NULL,
	[PicUrl] [varchar](200) NULL,
	[ProdID] [varchar](200) NULL,
	[StopTime] [int] NULL,
 CONSTRAINT [PK_StopList] PRIMARY KEY CLUSTERED 
(
	[StopID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[Product]    脚本日期: 11/22/2010 11:48:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Product](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](32) NOT NULL,
	[CurrentPage] [nvarchar](200) NULL,
	[ItemUrl] [nvarchar](200) NULL,
	[PicUrl] [nvarchar](200) NULL,
	[ProdID] [nvarchar](200) NULL,
	[ProcMoney] [varchar](20) NULL,
	[CreateDate] [datetime] NULL,
 CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[pro]    脚本日期: 11/22/2010 11:47:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pro](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](32) NOT NULL,
	[CurrentPage] [varchar](200) NOT NULL,
	[ItemUrl] [varchar](200) NULL,
	[PicUrl] [varchar](200) NULL,
	[ProdID] [varchar](200) NULL,
	[ProcMoney] [varchar](20) NULL,
	[CreateDate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Table [dbo].[ConfigList]    脚本日期: 11/22/2010 11:47:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConfigList](
	[sqlscript] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Allvisit]    脚本日期: 11/22/2010 11:47:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Allvisit](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](32) NOT NULL,
	[CurrentPage] [varchar](200) NOT NULL,
	[OS] [varchar](50) NOT NULL,
	[Browser] [varchar](50) NOT NULL,
	[sVisitors] [varchar](50) NOT NULL,
	[UserIP] [varchar](50) NOT NULL,
	[sLanguage] [varchar](50) NOT NULL,
	[RefPage] [varchar](200) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ALLVISIT] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

我用sqlcommand执行上面的SQL脚本，为什么不成功？

[zxcw12sadzxc]

GO
SET ANSI_PADDING OFF
GO
/****** 对象:  Trigger [Tri_生成月列表]    脚本日期: 11/16/2010 17:39:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create TRIGGER [dbo].[Tri_生成月列表] on [dbo].[Allvisit]
   for INSERT
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
	declare @CreateDate datetime
			,@CurrentPage	varchar(200)
			,@datecode varchar(10)
			,@pv int
			,@uv int

	select @CreateDate=CreateDate, @CurrentPage=CurrentPage from inserted
	set @datecode=convert(varchar(7),@CreateDate,120)


	select @pv=count(0) from Allvisit
	where CurrentPage=@CurrentPage and CreateDate=@CreateDate

	select @uv=count(0) from Allvisit
	where CurrentPage=@CurrentPage
	group by UserName

	if not exists(select 0 from MonthList where [ItemUrl]=@CurrentPage and [Datecode]=@datecode)
	begin

		INSERT INTO MonthList
				   ([Datecode]
				   ,[ItemID]
				   ,[ItemUrl]
				   ,[PV]
				   ,[UV]
				   ,[ItemTitle]
				   ,[PicUrl])
			 VALUES
				   (@datecode
				   ,''
				   ,@CurrentPage
				   ,@pv
				   ,@uv
				   ,''
				   ,'')
	end
	else
	begin
		update MonthList
		set [PV]=@pv
			,[UV]=@uv
		where [ItemUrl]=@CurrentPage and [Datecode]=@datecode 
	end

END
GO
/****** 对象:  Trigger [Tri_生成年列表]    脚本日期: 11/16/2010 17:39:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[Tri_生成年列表] on [dbo].[Allvisit]
   for INSERT
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
	declare @CreateDate datetime
			,@CurrentPage	varchar(200)
			,@datecode varchar(10)
			,@pv int
			,@uv int

	select @CreateDate=CreateDate, @CurrentPage=CurrentPage from inserted
	set @datecode=convert(char(4),@CreateDate,120)

	select @pv=count(0) from Allvisit
	where CurrentPage=@CurrentPage and CreateDate=@CreateDate

	select @uv=count(0) from Allvisit
	where CurrentPage=@CurrentPage
	group by UserName

	if not exists(select 0 from YearList where [ItemUrl]=@CurrentPage and [Datecode]=@datecode)
	begin

		INSERT INTO YearList
				   ([Datecode]
				   ,[ItemID]
				   ,[ItemUrl]
				   ,[PV]
				   ,[UV]
				   ,[ItemTitle]
				   ,[PicUrl])
			 VALUES
				   (@datecode
				   ,''
				   ,@CurrentPage
				   ,@pv
				   ,@uv
				   ,''
				   ,'')
	end
	else
	begin
		update YearList
		set [PV]=@pv
			,[UV]=@uv
		where [ItemUrl]=@CurrentPage and [Datecode]=@datecode 
	end

END
GO
/****** 对象:  Trigger [复制数据到PageList]    脚本日期: 11/16/2010 17:39:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE trigger [dbo].[复制数据到PageList] on [dbo].[Allvisit]
after insert 
as
 declare
		 @UserName varchar(32),
		 @CurrentPage varchar(200),
		 @OS varchar(50),
		 @Browser varchar(50),
		 @sVisitors varchar(50),
		 @UserIP varchar(50),
		 @sLanguage varchar(50),
		 @RefPage varchar(200),
		 @Createdate datetime
select @UserName=UserName,@CurrentPage=CurrentPage,@OS=OS,@Browser=Browser,@sVisitors=sVisitors,@UserIP=UserIP,@sLanguage=sLanguage,@RefPage=RefPage,@Createdate=Createdate from inserted
insert into PageList values(@UserName,@CurrentPage,@OS,@Browser,@sVisitors,@UserIP,@sLanguage,@RefPage,@Createdate)
GO
/****** 对象:  Trigger [my_trig]    脚本日期: 11/16/2010 17:39:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE trigger [dbo].[my_trig] on [dbo].[Allvisit] for insert
as
declare @CurrentPage varchar(200),
		@UserName varchar(32),
		@CreateDate datetime
select @CreateDate=CreateDate, @CurrentPage=CurrentPage,@UserName = UserName from inserted
if exists(select 1 from inserted where CurrentPage like 'http://www.100to.com/item.htm?id=%' or CurrentPage like 'http://item.taobao.com/item.htm?id=%' )--这里条件自己加,不过你的条件貌似不正确
begin
  insert into pro values (@UserName,@CurrentPage,'','','','',@CreateDate)
end
GO
/****** 对象:  Trigger [Tri_生成日列表]    脚本日期: 11/16/2010 17:39:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[Tri_生成日列表] on [dbo].[Allvisit]
   for INSERT
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
	declare @CreateDate datetime
			,@CurrentPage	varchar(200)
			,@datecode varchar(10)
			,@pv int
			,@uv int

	select @CreateDate=CreateDate, @CurrentPage=CurrentPage from inserted
	set @datecode=convert(char(10),@CreateDate,120)

	select @pv=count(0) from Allvisit
	where CurrentPage=@CurrentPage and CreateDate=@CreateDate

	select @uv=count(0) from Allvisit
	where CurrentPage=@CurrentPage
	group by UserName

	if not exists(select 0 from [DayList] where [ItemUrl]=@CurrentPage and [Datecode]=@datecode)
	begin

		INSERT INTO [DayList]
				   ([Datecode]
				   ,[ItemID]
				   ,[ItemUrl]
				   ,[PV]
				   ,[UV]
				   ,[ItemTitle]
				   ,[PicUrl])
			 VALUES
				   (@datecode
				   ,''
				   ,@CurrentPage
				   ,@pv
				   ,@uv
				   ,''
				   ,'')
	end
	else
	begin
		update [DayList]
		set [PV]=@pv
			,[UV]=@uv
		where [ItemUrl]=@CurrentPage and [Datecode]=@datecode 
	end

END
GO

[lihaoran8577]

将创建表和触发器放入数据库中，利用sqlcommand去执行！