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

字號:


    并以逗號分隔
    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