Archives for: "Feb 18 2005"

02/18/05

  08:48:04 am, by   , 150 words  
Categories: Programming

Extracting Column Names for a Table in SQL as a CSV String

I had a need (creating CSV BCP files) that required knowing the column names of a MS SQL table in the order they were created. Some inspiration from Mark Clerget and a little fooling around with SQL Query Analyzer resulted in the following. DECLARE @c v… more »
February 2005
Mon Tue Wed Thu Fri Sat Sun
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28            
 << < Current> >>

Search

  XML Feeds

Real Time Web Analytics
powered by b2evolution free blog software