sql拼接显示table的多个列 

SELECT DeptName AS text,CONVERT(VARCHAR(10),ID)+','+DeptCode+','+ISNULL(Remark,'') AS tags,'' AS href FROM  dbo.Sys_Dept

 

posted @ 2018-01-31 17:37  .NET_海  阅读(243)  评论(0)  编辑  收藏  举报