Getting Identity without Stored Procedure is a tutorial which explains you about getting the value of the identity field for the newly added record of the database table. In this tutorial author describes the procedure cleary with an example code.
This is an online stored procedure tutorial which simply and briefly explains about the usage of parameters in SQL stored procedures and from this article users can test and view the use of parameters in SQL stored procedure. Useful tutorial for...
This article instructs the database developers about stored procedure and the techniques to be followed by the users for generating their own ASP based SQL stored procedure. Stored procedure is actually used for separating the database...
This is an online database tutorial which helps the developers to use stored procedure on their project for displaying and editing hit reports on their web page. It uses SQL server as backend to store data and also the users can change procedure...
This article is helpful for the users who want to manage their database table and also it gives important notes to the users i.e- it explains about optional SQL stored procedure parameters with simple prototype in perceivable form to the users.
From this article database administrators can easily retrive their own records which is stored on multiple rows in a database table. It uses stored procedure to retrieve their records. Initially it creates temporary table to store query result and...
This PL/SQL stored procedure returns a person's age in whole years. It returns the number of whole years between two dates, and will also validate a date. Includes a stored function version.
File List:
@PSC_ReadMe_866_5.txt...
Stored Procedure used to determine the Linear Correlation between 2 variabes in a table of your database. This can also be used to determine the goodness of fit (Linear Regression) or best straight line between two columns of data in your...
ADO.NET, COBOL and Stored Procedures is a tutorial which contains more details about the stored procedure and how to get the data of the database table using the stored procedure. In this tutorial the author defines the stored procedure that helps...
Running Stored Procedures with ASP.NET is an useful tutorial which helps you to excute the user defined procedures with the help of the system stored procedure called as sp_stored_procedures. In this tutorial the author displays all the stored...
Views and Stored Procedures in Microsoft Access is a tutorial which clearly shows how query object in Micorosoft Access database can be used as a view and stored procedure. If you need query object to act as a view you simply mention the name of...
Why use Stored Procedures? is an article which discusses about the advantages and disadvantages of the stored procedures. Some of the advantages of using the stored procedure are speeds up the execution, easy to learn and use, easily find out the...
Working with MS Access Stored Procedures in VB.NET. Part 2 is a tutorial which helps you to learn about how to use the stored procedure that has been created in Access database using the database tier. The database tier is to provide a gateway to...
This is an useful tutorial section for database managers which gives several steps and tips about the creation of SPROC (Stored Procedure) and also it briefly demonstrates to the users how to use ADO commands with stored procedures.
This article basically explains about how to create stored procedure. Stored procedure is basically used for making easy to the users for managing their data records with security but with ease. Stored procedures with parameters is given in example.
This article completely explains about stored procedures by which the users can learn and operate with stored procedure techniques. It instructs the users in simple way i.e-even a layman can understand the usage of stored procedures. It explains...
In this article the author narrates about how to page through recordsets on a web page. The main advantages of this stored procedures are it can make good look pages and page loads for clients are much faster. The author tells about the usage of...
selectDelphi is a powerful and easy to use utility that generates Delphi classes that encapsulate the Stored Procedures and User Defined Functions of a SQL Server database.It's a tool for Developers who use MS SQL Server and want to take maximum...
This script is used for accessing data from SQL server using SQL stored procedure and gives report which is included with input forms to allow users to sort and paging function online from their webpage.
Avoid The Parameters Collection With The Microsoft .NET Data Provider For Oracle is an article which gives you the solution for getting the recordsets from the stored procedure with out using the parameter collection of the oracle command object.... | 
