由于mysql没有系统的学过,都是网上找的些资料,对mssql比较熟点,现想把mssql的语句转化为mysql,弄了半天,没试成功,还是到这里向各位高人帮忙写下吧,可能有好多种写,希望,多认识几种写法,在此先谢了。
mssql语句如下:
begin tran updateUserRights
delete from TUserRights where userNo = N'zhangshang'
insert into TUserRights(userNo,rightsNo) values(N'zhangshang',N'delete')
if @@error > 0 begin rollback tran updateUserRights end
commit tran updateUserRights
mssql语句如下:
begin tran updateUserRights
delete from TUserRights where userNo = N'zhangshang'
insert into TUserRights(userNo,rightsNo) values(N'zhangshang',N'delete')
if @@error > 0 begin rollback tran updateUserRights end
commit tran updateUserRights
还有,mssql这个语法在server2005中是没问题的了
查看一下这个内容,应该可以解决你的问题