SQL 分割字符串

最新推荐文章于 2019-11-11 20:25:57 发布

weixin_30760895

最新推荐文章于 2019-11-11 20:25:57 发布

阅读量58

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ChengPuYuan/p/3371931.html

 1 --插入选中了父节点的id
 2         while CHARINDEX(',',@PMenuIds)>1
 3         begin     
 4           
 5           DECLARE @PMenuId INT;
 6           SET @PMenuId=LEFT(@PMenuIds,CHARINDEX(',',@PMenuIds)-1);                                          
 7           
 8           --得到一个RightId，插入
 9           INSERT INTO RoleMenu(RoleCode,MenuID,Valid,CreatorID,CreateTime,UpdateEmployeeID,UpdateTime,IsParentNode)VALUES(@Code,@PMenuId,@Valid,@UpdateEmployeeID,GETDATE(),@UpdateEmployeeID,GETDATE(),1);
10                         
11           
12           --取到一个，删除一个
13           SET @PMenuIds=STUFF(@PMenuIds,1,CHARINDEX(',',@PMenuIds),'');
14          print @PMenuIds;
15         end            
16         INSERT INTO RoleMenu(RoleCode,MenuID,Valid,CreatorID,CreateTime,UpdateEmployeeID,UpdateTime,IsParentNode)VALUES(@Code,@PMenuIds,@Valid,@UpdateEmployeeID,GETDATE(),@UpdateEmployeeID,GETDATE(),1);
17