sql 事务,分隔符的截取

------ 添加或修改员工(涉及到了权限和角色)
create proc yt_AddOrUpt_User
@userid int,
@uname varchar(30),
@uage int,
@uloginname varchar(40),
@upassword varchar(40),
@departid int,
@usex int,
@udates datetime,
@utel varchar(20),
@uaddress varchar(50),
@roleids varchar(20), --此人的角色
@limitids varchar(50) --所有权限
as
begin
begin transaction
declare @errorsum int
set @errorsum=0
if(@userid <> 0)
 begin
  update userinfo set