纯新手，写个触发器，变量定义报错

[ralhander]

DECLARE @carid nvarchar(12)
这一句给我报错，知道咋回事的告诉我

[水族杰纶]

这个本身没有错
错其他地方了吧

[ralhander]

IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'tiu_carmsg' AND type = 'TR')
DROP TRIGGER tiu_carmsg
GO
CREATE TRIGGER tiu_CARMSG
ON CARMSG
for INSERT,update
as
begin
delete from clxxb where CLBH in(select carid from inserted);
DECLARE E1cursor cursor
DECLARE @carid nvarchar(12)

FOR SELECT * FROM inserted
OPEN E1cursor
FETCH NEXT from E1cursor
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT from E1cursor
END
CLOSE E1cursor
DEALLOCATE E1cursor
update clxxb set clzt='70' where CLBH in (select carid from inserted where inserted.CARSTATE='1');
update clxxb set clzt='20' where CLBH in (select carid from inserted where inserted.CARSTATE='2');
update clxxb set clzt='70' where CLBH in (select carid from inserted where inserted.CARSTATE='3');
update clxxb set clzt='140' where CLBH in (select carid from inserted where inserted.CARSTATE='4');
end;
go
全贴出来了，请指点

[喜-喜]

DECLARE E1cursor cursor
DECLARE @carid nvarchar(12)
FOR SELECT * FROM inserted


DECLARE @carid nvarchar(12)这句话写错位置了！


这样试试...
DECLARE @carid nvarchar(12)
DECLARE E1cursor cursor
FOR SELECT * FROM inserted

[华夏小卒]

CREATE TRIGGER tiu_CARMSG
ON CARMSG
for INSERT,update
as
begin
  delete from clxxb where CLBH in(select carid from inserted);
  DECLARE @carid nvarchar(12)   --这句放这
  DECLARE E1cursor cursor
  FOR SELECT * FROM inserted  
  OPEN E1cursor   

。。。。

[winstonbonaparte]

變量定義不能放在游標定義和游標的語句之間