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 As Web-based businesses begin to need more full-featured, powerful, and flexible technology systems, many are looking more closely at open-source options. From…
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
Writing external scripts to perform complex data handling is a tedious affair. The best way to automate tasks straightaway into the server is by using…