| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Insert and Return new row | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
MSchuch | 8096 since
12/6/2004 9:34:24 PM |
By 1 Users
|
| |
This stored procedure is a replacement for the sql Insert command. The major advantage of sp_Insert is that it returns the row that was just inserted.
Background: I frequently find my self in a situation where I need to insert a record into a table then i ...(description truncated) |
| |
| |
| |
|
 Insert Procedure Generator | SQL Server 7.0 | Advanced /
Wayne Gadberry | 19729 since
4/5/2001 6:37:32 PM |
By 6 Users
3 Excellent Ratings
|
| |
Produce an "insert" procedure with full transaction and error handling by simply passing a table name to the procedure. |
| |
| |
| |
|
Is SP running | SQL Server 2000 | Advanced /
Jonathan Spinks | 5696 since
10/1/2003 11:20:41 AM |
By 2 Users
2 Excellent Ratings
|
| |
This user defined function will tell you if a stored procedure is currently running. When you have a long running stored procedure executing you may wish to stop a second instance of it from being started. This function with the example will show you how. ...(description truncated) |
| |
| |
| |
|
IsAlphaNumeric | Other | Beginner /
Lewis E. Moten III | 5000 since
6/22/2002 11:33:02 AM |
By 2 Users
|
| |
Validates if the string provided contains only letters and numbers. |
| |
| |
| |
|
 Join the results of a stored procedure in T-SQL : A Clean Sample | SQL Server 7.0 | Intermediate /
Harinatha Reddy Gorla | 70386 since
2/19/2002 4:04:09 AM |
By 8 Users
8 Excellent Ratings
|
| |
There may be several instances where you have to join the results of a stored procedure with another query. Here's how to do it
|
| |
| |
| |
|
List Directories and Files using T-SQL | SQL Server 2000, SQL Server 7.0 | Intermediate /
TheIndoctrinator !! | 48519 since
6/22/2005 5:42:26 AM |
By 2 Users
2 Excellent Ratings
|
| |
Hi, This is my 6th submission, "An Intro to List File and/or Folders of any machine using T-SQL Producedurs." This code is not mine but of Mr. Brian Walker, senior database architect in an IS
department that uses SQL Server 2000 and the .NET Framework. I ...(description truncated) |
| |
| |
| |
|
Logfiles by PL/SQL | Oracle | Intermediate /
Stephan Rechberger | 5587 since
10/21/2002 4:00:29 AM |
By 3 Users
|
| |
Writes Log-Files in a Directory by using UTL_FILE. |
| |
| |
| |
|
Lord of the ring :) optional search | SQL Server 2000 | Intermediate /
Observer123 | 4302 since
9/10/2004 11:09:21 AM | Unrated
|
| |
This is stored procedure for optional table search, can be used as a template for search engines.
We receive cumulative result even if not all search parameters are filled. |
| |
| |
| |
|
MAINTENANCE_MONITOR_CATALOGS | SQL Server 2000 | Advanced /
Peter Marquie | 3038 since
2/1/2003 8:38:55 PM | Unrated
|
| |
DETERMINE THE STATUS OF ALL FULL TEXT CATALOGS ON A GIVEN SERVER |
| |
| |
| |
|
More friendly version of sp_lock | SQL Server 7.0 | Advanced /
Eli Leiba | 5489 since
3/19/2002 8:29:54 AM |
By 1 Users
|
| |
takes the output of sp_lock and genrates a more
readable output info. |
| |
