新手！紧急求助：根据删除纪录的某个字段的值来执行不同的sql语句

Question

CREATE TRIGGER [input_Delete] ON [dbo].[storage_input] 
FOR  DELETE 
AS
declare @trans bit
select @trans=sin_trans from deleted
if @trans=0
  sql1
else 
  sql2

Answer 1

CREATE TRIGGER [input_Delete] ON [dbo].[storage_input] 
FOR  DELETE 
AS
declare @trans bit
select @trans=sin_trans from deleted
if @trans=0
  sql1
else 
  sql2

Answer 2

CREATE TRIGGER [input_Delete] 
ON [dbo].[storage_input] 
FOR  DELETE 
AS
declare @trans bit
 select @trans=sin_trans from deleted
if @trans=0
  begin
 sql1
 end

Answer 3

CREATE TRIGGER [input_Delete] ON [dbo].[storage_input] 
FOR  DELETE 
AS
declare @trans bit
select @trans=sin_trans from deleted
if @trans=0
beign
  sql1
end
else 
begin
  sql2
end