2017計(jì)算機(jī)等考三級(jí)數(shù)據(jù)庫(kù)基礎(chǔ):把表的所有字段名輸出到一個(gè)字段中

字號(hào):


    并以逗號(hào)分隔
    Declare @S Nvarchar(4000)
    Set @S=''
    --Select @S=@S+','+Name from SysColumns Where ID=OBJECT_ID(N'Tb_Article')
    --Select @S=Stuff(@S,1,1,'')
    --Select @S