DECLARE @Name NVARCHAR(MAX)='' SELECT @Name =@Name+ CASE(LEN(@Name)) WHEN 0 THEN '' ELSE ',' END +FirstName+LastName FROM dbo.Sys_Users PRINT @Name
把用户名连成字符串的sql语句.
最新推荐文章于 2021-01-28 00:36:31 发布
DECLARE @Name NVARCHAR(MAX)='' SELECT @Name =@Name+ CASE(LEN(@Name)) WHEN 0 THEN '' ELSE ',' END +FirstName+LastName FROM dbo.Sys_Users PRINT @Name