Saturday, 18 November 2017

Using STUFF get multiple column Names in sing string in sql server


//// Sql

DECLARE @cols AS NVARCHAR(MAX),@Flg varchar(10)='18'
select @cols = STUFF((SELECT distinct ',[' + Description + ']' FROM mstLookup where lookupflag=@Flg FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')

print @cols


//// Result



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...