qq_25128693的博客

SQLSERVER存储过程事务

SQLSERVER拆分逗号分隔的字段为多条数据。

– 声明变量DECLARE@BuCode AS varchar(max)– 声明游标DECLARE C_Employees CURSOR FAST_FORWARD FORSELECT BUCodeFROM myBusinessUnit WHERE ParentGUID IS NOT NULL;OPEN C_Employees;– 取第一条记录FETCH NEXT FROM C_Employees INTO @BuCode;WHILE @@FETCH_STATUS = 0BEGIN–P

场景:2个表一个存储逗号分隔得系统编号 现在需要将系统编号转换为实际系统名称1.行转列将项目表的ApplySys 拆分为多条数据SELECT ApplySys , * FROM p_projectSELECT * FROM dbo.myApplication–行转列SELECT ProjGuid,ApplySys,c.ApplicationName FROM (SELECT A.ProjGuid, B.ApplySysFROM(SELECT p_projectId ProjGuid