Your Technical Consultant
In this post, we discuss best practices for split comma delimited string SQL Server. Many a time we come across a scenario where we pass a comma or any other character delimited string to stored procedure and in a stored […]
Continue reading How to Split comma delimited string into a Table in SQL Server
Want to bring your ideas to life, to make them take up residence in the reader’s mind, lurking in the background, tugging, pulling, and cajoling their emotions until they think and feel exactly as you want? Then you’re going to love […]
Continue reading The Ultimate List: 801+ Power Words to Supercharge Your Marketing
This is a new feature intorduced in Sql Server 2008. Table-Valued Parameters provides option for the Client Applications to pass multiple rows of Data to Stored Procedure.
Prior to this, if we were needed to pass multiple rows of Data from client application to Sql Server, then we use to model the input data as xml and pass it to the stored procedure and in Stored Procedure convert this xml to a table variable/temporary table.
Continue reading Understanding Table-Valued Parameters in SQL Server for Better Performance
