首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

!触发器跳不过去?

2012-01-23 
求助!!!触发器跳不过去???create trigger interg_disc on membersfor update asbegin/*declare @memberID

求助!!!触发器跳不过去???
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 行
' ' 附近有语法错误。

[解决办法]
interg_disc后又一个全角空格
[解决办法]
这样就行了.

SQL code
create trigger interg_discon membersfor updateasbegindeclare @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=@memberIDend
[解决办法]
begin和end之间要有内容

热点排行