自己寫的sql server觸發器練練--高手請您跳過吧

標籤：ar   for   sp   2014   c   on   r   ad   bs   

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

 

ALTER TRIGGER [insertReplyToic]
ON [dbo].[bbsReplyTopic]
AFTER insert
AS
BEGIN
--SET NOCOUNT ON;

-- Insert statements for trigger here

declare @uid int,@topicId int,@Rcontent nvarchar(max),@Rtime datetime,@ccode varchar(max)
,@uname nvarchar(50),@beReplyedUid int,@beReplyedUname nvarchar(50),@replyTid int,@insertId int;
insert into bbsReplyTopic values(
@uid,@topicId,@Rcontent,@Rtime,@ccode,@uname,@beReplyedUid,@beReplyedUname,@replyTid
) select @[email protected]@identity
if(@insertId!=0)

select @topicId=topicId from inserted
update bbsTopic set replyCount=replyCount+1 where [email protected]
print ‘您剛剛插入的id是‘+convert(varchar(10),@insertId)+‘,success‘

END

 

insert into bbsReplyTopic values(125,291,‘test‘,‘2014/10/6 00:00:00‘,‘chadao‘,‘zhangziyi‘,125,‘zhangziyi‘,0)

自己寫的sql server觸發器，當回帖文章被回複時，文章的回複數量欄位就加1

測試成功！

 

自己寫的sql server觸發器練練--高手請您跳過吧