Tag Archives: comma-separated string

Retrieving column values as a comma separated string in SQLServer

Hi, This post is quite the opposite of the previous post. That is, in the previous post, We inserted a comma separated string into separate rows. Here we will return a single comma separated string by concatenating values from separate rows.   … Continue reading

Posted in CodeProject, General, SQL Server | Tagged , , , , | Leave a comment

Adding items in comma-separated string into separate rows in SQLServer

Hi, In this post, I’ll show how to insert a items in a comma-separated string into separate rows in a table. Consider for example we have a comma-separated string such as “amogh, anish, anvesh, uday”. after inserting into the table, … Continue reading

Posted in CodeProject, General, SQL Server | Tagged , , , , | 1 Comment