Comments

12/29/2014 | samwids  United States
Comma separated column name - sql server

Select TABLE_SCHEMA, TABLE_NAME
    , Stuff(
        (
        Select ', ' + C.COLUMN_NAME
        From INFORMATION_SCHEMA.COLUMNS As C
        Where C.TABLE_SCHEMA = T.TABLE_SCHEMA
            And C.TABLE_NAME = T.TABLE_NAME
        Order By C.ORDINAL_POSITION
        For Xml Path('')
        ), 1, 2, '') As Columns
From INFORMATION_SCHEMA.TABLES As T
where T.TABLE_NAME = 'Logs'

Add Comment Post comment

 
 
 
   Country flag

Loading

For mobile, tablets or touch devices, if verify button is disabed, please press Enter after entering captcha verfication text than click Verify button.



Read in the name of your Lord Who created. Created the man from a (blood) clot. Read! Your Lord is the Most Generous, Who taught writing by the pen. Taught man what he knew not. (Holy Quraan - Al Alaq - 96-1to5)
8,735,322 hits.
© 2001-2018 Muhammad Faisal | Disclaimer | Contact
Partner Sites (Web | Videos | Photos)