Calling Stored Procedures from ASP.NET and VB.NET
Let us see how can we create and call Stored procedures, in a .NET Environment, i.e Visual Studio. We use .NET 2.0 and Visual Studio…
Database driven websites The needs of online businesses are constantly evolving, requiring more capable technology. Many are discovering the benefits of open-source solutions. These offer…
Stored Procedures are special types of functions that can execute under the SQL Server Environment. SPs are said to be building blocks of any web…
A to Z of stored procedures for ASP and VB Programmers
The article is meant for ASP and VB Programmers, who always try to write hard core SQL statements embedded in their coding to communicate with…
Here is some practice tips which you can remember and apply when writing SPs Use SET NOCOUNT ON, this will reduce unnecessary return values as…
Using Stored procedure with mySQL and PHP
Using external scripts for complex data handling is often a tedious process. Stored Procedures provide a superior solution by automating tasks directly within the database…