Thursday, 25 February 2016

Sql server table columns with comma separated string using COALESCE


//Sql Query

DECLARE @ColStr VARCHAR(MAX)
SELECT @ColStr = COALESCE(''+@ColStr +',' ,'') +'['+ name+']' FROM sys.columns where object_name(object_id)='TableName'

Print @ColStr


// Result

 [Active],[StateCode],[StateName]

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...