SQL Server Stored Procedures Insert Retrieve Update Delete Operations

In database, you need to do Insert, Update and Delete. If we want to make a reliable and high performance system then these four operations must be implemented by stored procedures. Stored procedur…

Read more »
13 Mar 2014

Insert Comma Seperated String Data into Rows in SQLServer AspDotnetInsert Comma Seperated String Data into Rows in SQLServer AspDotnet

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, uda…

Read more »
13 Mar 2014

Select Column Values as Comma Seperated String in SQLServerSelect Column Values as Comma Seperated String in SQLServer

The query for this is very simple. Say, our table has two columns, UserId and UserName. And we want a list of usernames as comma-separated string, then the query would be SELECT UserName + ‘,’ FROM…

Read more »
10 Mar 2014
 
Top