SQL Server – Create and Parse Comma Seperated List

XML Approach:
Reads : 2 Duration:5 ms

Substring Approach:
Reads : 16 Duration: 14 ms

 Quick Way to Create Comma Seperated List using STUFF and XML PATH

— STUFF SYNTAX
— STUFF ( character_expression , start , length , replaceWith_expression )

Leave a Reply

Your email address will not be published. Required fields are marked *

*