Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Comma Separated List Of Field Names

By smartinez,

Returns a single row with a single column containing a comma-separated list of the field names for a specified table. I find this very useful when doing INSERT statements where I have to list out each field being inserted. I simply bind this proc to a hotkey and use the hotkey to get the comma-separated list of fields.

Total article views: 386 | Views in the last 30 days: 2
 
Related Articles
FORUM
SCRIPT

Auto generation key field

Auto generation key field

FORUM

change collation field

change collation field

FORUM

Incrementing a field

Incrementing a field

FORUM

JOIN on two fields

JOIN on 2 fields

Tags
miscellaneous    
 
Contribute