Utilizing Parameters in SQL Stored... - TAG Consulting

ASP / Tips and Tutorials / Database Management

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...

Create an ASP SQL Stored Procedure - Jeff Anderson

ASP / Tips and Tutorials / Database Management

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...

Hit counter Using Stored Procedure - Gazatem Tech Network

ASP / Tips and Tutorials / Database Management

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...

Optional SQL Stored Procedure Parameters - TAG Consulting

ASP / Tips and Tutorials / Database Management

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.

Select Random Row Using Stored Procedure - Steven Smith

ASP / Tips and Tutorials / Database Management

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...

Compute Age 0 - Andy Archer

SQL / Date/ Time

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...

Data Correlation o - VISUAL-BASIC.NET

SQL / Data Warehouses

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...

Getting the ID number of an inserted... - Aaron Bertrand

ASP / Tips and Tutorials / Database Management

Now the developers can retrieve the ID number of a just inserted record with the help of this online article. With the help of SQL server it is good to use a single stored procedure which executes both the INSERT and the IDENTITY operation using...

ADO.NET, COBOL and Stored Procedures - Rick Malek

ASP.NET / Tips and Tutorials / Database Tools

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...

Avoid The Parameters Collection With... - Jonathan Goodyear

ASP.NET / Tips and Tutorials / Database Tools

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....