对不起,写错了:
insert into sysrole values (1,'管理员')
insert into sysrole values (2,'普通用户')
insert into sysrole values (3,'测试')
insert into sysrole values (4,'角色1')
insert into sysrole values (5,'角色2')
insert into sysrole values (6,'角色3')
insert into sysrole values (1,'管理员')
insert into sysrole values (2,'普通用户')
insert into sysrole values (3,'测试')
insert into sysrole values (4,'角色1')
insert into sysrole values (5,'角色2')
insert into sysrole values (6,'角色3')
select * from deleted where jsbh in(1,2,3,4,5,6)
if @@rowcount>0
ROLLBACK TRANSACTION
比如:
delete from sysrole
这时我想删除除了管理员'和'普通用户'之外的用户
select * from deleted where jsbh in(1,2)
if @@rowcount>0
ROLLBACK TRANSACTION
on sysrole
instead of delete
as
select * from deleted where jsbh in(1,2)
if @@rowcount>0
ROLLBACK TRANSACTION
else
delete sysrole from deleted where sysrole.jsbh = deleted.jsbh
genny(阿健) 10分yzssg(秋枫) 10分
on sysrole
instead of delete
as
select * from deleted where jsbh in(1,2)
if @@rowcount>0
ROLLBACK TRANSACTION
else
delete sysrole from deleted where sysrole.jsbh = deleted.jsbh
改自于楼上的,呵呵