Obtain all columns separated by commas (,) in a table or view.

Obtain the development environment of all columns separated by commas (,) for a table or view: in SQL Server 2005, we often need to obtain all columns of a table or view during work, return a comma-separated column name. The following are two methods: 1. Directly drag 【 Column] Table query analyzer. 2. Write the program process. Because it is a stored procedure starting with SP _, it is recommended to write it in the master database so that it can be called in any database. The script is as follows: if object_id ('SP _ gettablecolumns ', 'P ') is not nulldrop proc sp_gettablecolumnsgo/********************** proc: sp_gettablecolumnsuse: Get a table or view with comma ', 'create by: Mark yaocreate Date: 2008/7/3 input: @ tblname table or view name output: E. g: sp_gettablecolumns 'teaminfo' *********************/create proc sp_gettablecolumns @ tblname nvarchar (200) asselect substring (select ',' + name from syscolumns where id = object_id (@ tblname) order by colorder for XML Path (''), 2,1000) Go