select stuff((select ','+name from
(select A.name from syscolumns A, sysobjects B
where A.id = B.id
and B.name ='zp_instruction'
) a
for xml path('')),1,1,'') as 表的所有字段
sql一次性列出表中的所有字段名
最新推荐文章于 2024-03-19 15:02:52 发布
select stuff((select ','+name from
(select A.name from syscolumns A, sysobjects B
where A.id = B.id
and B.name ='zp_instruction'
) a
for xml path('')),1,1,'') as 表的所有字段