CREATE TRIGGER music ON [dbo].[obj_music]
FOR INSERT
ASif(select [Action] from obj_music) = 'A'
begin
--raiserror('add news',16,1)
--rollback transaction
end
else if (select [Action] from obj_music)= 'M'
begin
--raiserror('modify news',16,1)
--rollback transaction
end
else if(select [Action] from obj_music)='D'
begin
--raiserror('delete news',16,1)
--rollback transaction
end****
如题,当判断了字段之后,begin后面怎么样写,让表[dbo].[obj_music] 中的数据分别存入三了临时表???
FOR INSERT
ASif(select [Action] from obj_music) = 'A'
begin
--raiserror('add news',16,1)
--rollback transaction
end
else if (select [Action] from obj_music)= 'M'
begin
--raiserror('modify news',16,1)
--rollback transaction
end
else if(select [Action] from obj_music)='D'
begin
--raiserror('delete news',16,1)
--rollback transaction
end****
如题,当判断了字段之后,begin后面怎么样写,让表[dbo].[obj_music] 中的数据分别存入三了临时表???
没有查询条件么?
这样的判断根本执行不了啊!
else if(select action from obj_music)= 'M'
else if(select action from obj_music)='D'这样行不行?我想判断 Action列中的字段,写出来发现action是关键字,不知道action关键字是起什么作用,所以加了个括号.
declare @acn char(1)
set @acn=(select [action] from obj_music)
if @acn='A'
...
else if @acn='M'
...
else if @acn='D'
...