CREATE PROCEDURE [up_Gather_Page_Insert]@ID uniqueIdentifier,
@SiteID int,
@URL nvarchar (150),
@Title nvarchar (250),
@Content ntext,
@AllPageContent ntext,
@Summary ntext,
@SaveTime datetime,
@GatherType int,
@Result int output --这个要传出去的AS
declare @count int
select @count=count(*) from T_Gather_Page where URL=@URL and Title=@Title--判断是否存在相同的URL和Title
if @count > 0
set @Result=0
else
begin
insert into T_Gather_Page([ID],SiteID,URL,Title,Content,AllPageContent,Summary,SaveTime,GatherType)
values (@ID,@SiteID,@URL,@Title,@Content,@AllPageContent,@Summary,@SaveTime,@GatherType)
set @Result=1
endGO
@SiteID int,
@URL nvarchar (150),
@Title nvarchar (250),
@Content ntext,
@AllPageContent ntext,
@Summary ntext,
@SaveTime datetime,
@GatherType int,
@Result int output --这个要传出去的AS
declare @count int
select @count=count(*) from T_Gather_Page where URL=@URL and Title=@Title--判断是否存在相同的URL和Title
if @count > 0
set @Result=0
else
begin
insert into T_Gather_Page([ID],SiteID,URL,Title,Content,AllPageContent,Summary,SaveTime,GatherType)
values (@ID,@SiteID,@URL,@Title,@Content,@AllPageContent,@Summary,@SaveTime,@GatherType)
set @Result=1
endGO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货