TODO:
Have you ever wanted to get a comma separated list of columns that belong to a table using T-Sql?
SOLUTION:
DECLARE @columnList varchar(8000)
DECLARE @name varchar(100)
DECLARE db_cursor CURSOR FOR
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'MyTable'
ORDER BY COLUMN_NAME ASC;
SET @columnList=''
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
IF @columnList=''
SET @columnList = '[' + @name + ']'
ELSE
SET @columnList = @columnList + ',[' + @name + ']'
FETCH NEXT FROM db_cursor INTO @name
END
CLOSE db_cursor
DEALLOCATE db_cursor
SELECT @columnList
NOTES:
Just paste to a query window, hit ctrl-a and F5 to run it.
TODO:
Have you ever wanted to convert a List<string> to a comma delimited string?
SOLUTION:
List<string> list = new List<string>();
list.Add("blah");
list.Add("blah1");
list.Add("blah2");
list.Add("blah3");
string result = String.Join(",", list.ToArray());
NOTES:
There are no notes on this topic.