sql server 2005中沒有等於等於，高手自行跳過。。

標籤：style   color   ar   for   sp   c   on   r   ad   

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER TRIGGER [qiandaoTrigger]
ON [dbo].[bbsQianDao]
AFTER insert
AS
BEGIN
--SET NOCOUNT ON;
declare @uid int,@count int;
select @uid=uid from inserted
select @count=count(*) from inserted where [email protected] and hadreward=0
if(@count=2) --沒有等於等號（即==）
begin
update bbsUserReward set forumGold=forumGold+2 where [email protected]
update bbsQianDao set hadreward=1 where [email protected]
end
END

sql server 2005中沒有等於等於，高手自行跳過。。