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

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

QUICK TIP: Getting Identity without... - Chris Garrett

ASP / Tips and Tutorials / Database Management

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.

SQL: Custom WHERE in SPROC - Steven Smith

ASP / Tips and Tutorials / Database Management

Through this online article the developers could easily understand about how to use Custom WHERE Clause efficiently while building a SQL stored procedure. In this article the author narrates about the SQL stored procedures used for a search...

ASP Data Driven Web Report - Exhedra Solutions, Inc.

ASP / Database Tools

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.

MS SQL Server Extended Stored... - Leonid Belousov

Delphi / DataBase - Misc.

Write Extended Stored Procedures for Microsoft SQL Server with ease: Supported control over input/output procedure parameters. Supported returning of arbitrary number of recordsets. .....

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

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

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