求助！！！触发器跳不过去？？？

[lzysheva]

create trigger interg_disc　
on members
for update　
as
begin
/*declare @memberID int,@integral int
select @memberID=memberID ,@integral=integral from members where status='true'
if(@integral>300 and @integral<600 )
update members set discount=0.8 where memberID=@memberID
else if(@integral>600)
update members set discount=0.7 where memberID=@memberID
update members set status='false' where memberID=@memberID*/
end

跳出：消息 102，级别 15，状态 1，第 1 行
'　' 附近有语法错误。

[billpu]

interg_disc后又一个全角空格

[dawugui]

最好给出完整的表结构,测试数据,计算方法和正确结果.否则耽搁的是你宝贵的时间。
如果有多表,表之间如何关联?

发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281

[-晴天]

这样就行了.

create trigger interg_disc
on members
for update
as
begin
declare @memberID int,@integral int
  select @memberID=memberID ,@integral=integral from members where status='true'
  if(@integral>300 and @integral<600 )
  update members set discount=0.8 where memberID=@memberID
  else if(@integral>600)
  update members set discount=0.7 where memberID=@memberID
  update members set status='false' where memberID=@memberID
end

[yy1987316]

begin和end之间要有内容