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 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 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 is an useful database tutorial for the users which helps the users to refer the details about how to display database records from database using stored procedures. It provides several tips and hints that the users to be followed in a simple...
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...
This article instructs and practices database administrators to update records in database using stored procedures. It uses several procedures in SQL statements for updating records. This tutorial is easy to understand and the given codes are...
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... | 
