No equals equals in SQL Server 2005, the master skips by itself.

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) -no equals equals sign (= =)
Begin
Update Bbsuserreward set forumgold=forumgold+2 where [email protected]
Update Bbsqiandao set hadreward=1 where [email protected]
End
END

No equals equals in SQL Server 2005, the master skips by itself.