摘要: 方法一: 使用T-SQL DECLARE @Users NVARCHAR(MAX) SET @Users = '' SELECT @Users = @Users + ',' + UserName FROM dbo.[User] WHERE RoleID = 1 SELECT @Users 转载自:h 阅读全文
posted @ 2016-04-08 16:49 Coder.King 阅读(1706) 评论(0) 推荐(0) 编辑
摘要: SELECT 表名 = Case When A.colorder=1 Then D.name Else '' End, 表说明 = Case When A.colorder=1 Then isnull(F.value,'') Else '' End, 字段序号 = A.colorder, 字段名 = A.name, ... 阅读全文
posted @ 2016-04-08 09:31 Coder.King 阅读(253) 评论(0) 推荐(0) 编辑