Select DISTINCT STUFF(( SELECT ‘,‘ + name FROM SysColumns WHERE id = a.id FOR XML PATH(‘‘) ), 1, 1, ‘‘) Name FROM SysColumns a Where id=Object_Id(‘TableName‘)
在navicate中定义查找列名快捷方式
原文:https://www.cnblogs.com/quwujin/p/12040636.html