Introduction In this article, I will discuss how can we improve SQL query performance. Several times you have seen your SQL stored procedure or query getting too much slow. which is one of the primary reasons for your application slowness. So in this article, I will discuss a few easy SQL query optimization steps by which you can improve your SQL…
Category: SQL
How to pass data-table as parameter to a stored procedure in MSSQL from C# Application
Introduction Here I will discuss how to pass/send a data-table as parameter to a stored procedure from c# application.In other words, we can say how to pass table valued parameter as parameter in the stored procedure in SQL server. When we are sending one line of query to the stored procedure that time, we can send our defined variable, during…