Similar articles
DotNetShoutout - Latest published stories
Asp.Net Stored Procedure Parameters
Use Parameters in Stored procedures Using stored procedures in asp.net application helps in various ways to run couple of SQL statements, and makes the applications to get the data by calling those p...
9Lessons
Stored Procedure Lesson
Are you writing Stored Procedures if not please take a look at this post. Stored procedures can help to improve web application performance and reduce database access traffic. In this post I want to e...
DotNetShoutout - Latest published stories
Stored Procedure in WCF Data Service
In this article we will explore, how could we use Stored Procedure with WCF Data Service? You can read Introduction to WCF Data service and ODATA here To use Stored Procedure, at time of creation of D...
DotNetShoutout - Latest published stories
Stored Procedure to Get Expensive Queries
As a DBA we often need to get information on various Queries, One of them is how expensive it is. A query can be judged as expensive on various criteria’s like Long Running, Memory Utilization, CPU ut...
Journey to SQL Authority with Pinal Dave
SQL SERVER – Stored Procedure and Transactions
I just overheard the following statement – “I do not use Transactions in SQL as I use Stored Procedure“. I just realized that there are so many misconceptions about this subject. Tra...
ASP.NET Weblogs
Entity framework and Stored procedure output parameter
One of my friend was having problem in Entity framework and stored procedure output parameter. He was confused how to use output parameter with stored procedures.So I did some search on internet and I...