×
Add Your Listing

Using Stored Procedures with MSSQL and ASP.NET 2.0

How to migrate your existing in line SQL to Stored Procedures with MSSQL and ASP.NET 2.0
Send Query
Posted by Scripts on 2022-08-17 08:13:34
License Type
License Type
Freeware
Description
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.
Author

handy01

Using Stored Procedures with MSSQL and ASP.NET 2.0 QRCode
Other Categories

Statistics
  • 80Views
  • Ratings
Ratings & Review
Uh oh! We couldn't find any review for this listing.
Post Review
License Type
License Type
Freeware