Friday, October 9, 2009

sql server table column list with comma as seperator

Below function mostly will be used for automated tasks in SQL Server to produce the insert statements for data population and migration from other systems.

make sure to use the schema name with the table name eg: dbo.customers or sales.customer.
select dbo.fnColList 'dbo.customers'

No comments:

Post a Comment

Featured Post

SQL Server AWS Migration BCP

stored procedure to generate BCP scritps to migrate the SQL Server database. Developed this stored procedure on my labs to simulate t...