请帮我看看这段代码有何错误(50分)
20hao 2004-02-23 11:21:49 提示信息:
错误170:第6行:‘:’附近有语法错误。在关键字then附近有语法错误
CREATE TRIGGER liu_kill ON [dbo].[persondossier]
FOR INSERT
AS
declare @liu int
select count(*)
into :liu
from persondossier
if liu>1000 then
rollback;
else
commit;
end if