Instantly share code, notes, and snippets.

Embed
What would you like to do?
Comma deliminate a collection a data to a singe column
GO
DECLARE @tableName VARCHAR(MAX)
SELECT @tableName = COALESCE(@tableName + ',' ,'') + Name
FROM sys.tables
SELECT @tableName
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment