How to add single quotes in stuff for all values

declare @columnlist1 nvarchar(max) = stuff((select ',' + ''''+ cast(s.name as varchar(max)) + '''' from sys.columns s where s.object_id = object_id('ws_user_flat_t_test264') and s.name not in ('id') order by column_id for xml path('')), 1, 2, '') print @columnlist1 the o/p is as below: includeAnniversaryInTicker','includeBirthdayInTicker','includeReceivedAwardsInTicker','Service_Date' I need single quote for first value too like below.How to achieve this? 'includeAnniversaryInTicker','includeBirthdayInTicker','includeReceivedAwardsInTicker','Service_Date'

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg commented · Aug 11, 2017 at 07:41 PM

@sindhu Your script is almost correct, but you accidentally force the very first single quote to be removed because you use stuff(Input, 1, 2, '') so it removes the very first single quote along with the leading comma. The third parameter for stuff in your case should be 1, not 2, i.e. declare @columnlist1 nvarchar(max) = stuff(( select ',' + ''''+ cast(s.[name] as varchar(max)) + '''' from sys.columns s where s.[object_id] = object_id('ws_user_flat_t_test264') and s.name 'id' order by column_id for xml path('')), 1, 1, '') print @columnlist1

0 ·