what is the exact use of Stuff in sql server
In my stored procedure I have a statement like this
select @cols = STUFF((SELECT distinct ',' + QUOTENAME(Vtype) from VType_tbl
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')
i dont know what exactly would happen with these statement? why we are
using Stuff and QUOTENAME and ; for XML PATH
No comments:
Post a Comment