No Images Added Yet

Using Stored Procedures with MSSQL and ASP.NET 2.0

Rated5.0/5 (3 ratings)
Add to Favorites
How to migrate your existing in line SQL to Stored Procedures with MSSQL and ASP.NET 2.0
Product Details

If you haven't used MSSQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. In this article I will list down basic questions like the following :what is a stored procedure? How can I create a stored procedure? How can I use it from within my ASP.NET 2.0 web pages? And how can I return an output parameter value to my ASP.NET web page? A stored procedure is a script of SQL code that is stored in your database under a given name. The SQL code for the stored procedure may contain programming logic (using T-SQL IF and CASE statements for example) and SELECT, INSERT, UPDATE or DELETE statements as well. There are many benefits using stored procedures instead of writing pure SQL code. 1. Reduce Network Usage between WebServer and Database Server. 2. Code Reuse. 3. Faster in performance . 4. Enhance Security as you can only give your user execute permission on your stored procedure.

Report this Listing
Licence Type
Submitted on
14th November 2007
Last Updated
14th November 2007
Licence Type
License Price

You May Also Like

User Reviews

Please rate the listing and tell the world know what do you think about the listing.
(3 ratings)
Average User Rating: 5.0/5
No reviews found.
Not yet reviewed by any member. You can be the first one to write a review for this listing.Click hereto submit your review.