| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 insert into one table all rows from another table (no duplicates), with one SQL statement | Oracle | Intermediate /
Andy Archer | 86484 since
3/11/2009 10:58:34 AM |
By 7 Users
6 Excellent Ratings
|
| |
The example SQL and narrative illustrate how to insert into one table all rows from another table, without pulling over duplicates (including null row duplicates), via an Insert statement with subqueries. Merge example also included. |
| |
| |
| |
 |
 Search for a String in all/any Tables + in all/any Columns in a Database. Updated. | SQL Server 2000 | Intermediate /
Raghavendra Narayana | 9060 since
3/25/2003 2:29:32 AM |
By 7 Users
6 Excellent Ratings
|
| |
SEARCH FOR A SPECIFIC INTEGER/STRING IN THE ENTIRE TABLES IN THE DATABASE. Search for a String/Integer without specifying Table and/or Column name. If you dont know OR not sure about the table/column name in the database to search for a specific string/in ...(description truncated) |
| |
| |
| |
|
sp_sessBCP | SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
John C Kirwin | 14799 since
12/13/2000 4:35:42 PM |
By 7 Users
6 Excellent Ratings
|
| |
Bulk Copy(BCP) data out of one or all tables from a specified database and specified server to one or all tables in a database on the same or different server. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
TSQL Encryption TEA, RC4, Vigenere, Caesar, XOR | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Intermediate /
Joseph Gama | 12066 since
6/17/2003 11:23:16 PM |
By 7 Users
6 Excellent Ratings
|
| |
Encrypt fields with these stored procedures and functions: TEA (new variant), TEA, RC4, Vigenere, Caesar, XOR, XOR8 for SQL Server This is a collection of stored procedures and encryption functions (UDF's) in TSQL.<BR> |
| |
| |
| |
|
 UNION statements in MySQL 3.x | Other | Intermediate /
Michael Bailey | 21488 since
11/13/2002 6:32:05 PM |
By 7 Users
6 Excellent Ratings
|
| |
Everyone who uses MySQL realizes eventually that while being a very powerful SQL server, a number of options are missing. One of these is the UNION statement. Here's how to do it in MySQL 3.x |
| |
| |
| |
|
Construct your Own create table script | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Eli Leiba | 27286 since
1/1/2002 5:35:54 AM |
By 8 Users
6 Excellent Ratings
|
| |
The code gets the necessary info from information
schema to contsruct a CREATE table statement
existing in the current database |
| |
| |
| |
|
Decrypt/Display Large SQL 2000 Stored Procedures v1.00.1 | SQL Server 2000 | Advanced /
Jonathan Spinks | 15079 since
7/24/2003 12:11:55 PM |
By 8 Users
6 Excellent Ratings
|
| |
This stored procedure will allow you to display or decrypt very long encrypted stored procedures (40,000 chars). This sp will also keep / display any permissions associated with it.
The original concept for this code came from Joseph Gama (Nice work! Coul ...(description truncated) |
| |
| |
| |
|
 Introduction to PL/SQL (Series 3) Cursors | Oracle | Beginner /
davepamn | 61612 since
11/25/2011 5:24:50 PM |
By 8 Users
6 Excellent Ratings
|
| |
PL/SQL introduces a new dimension of power programming capability for the developer. The goal of reusable code measurely improves quality verse vast amounts of non-reusable SQL. PL/SQL packages describe function and procedure specification and body. The s ...(description truncated) |
| |
| |
| |
|
Source Code Generator | SQL Server 2000, SQL Server 7.0 | Advanced /
NAGABHUSHANAM | 6932 since
8/18/2003 5:32:06 AM |
By 8 Users
6 Excellent Ratings
|
| |
This procedure may be used to create an insert, Update and Delete SP's for a table |
| |
| |
| |
|
Find out which service pack is installed. | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Peter Schmitz | 5370 since
12/5/2001 12:07:16 PM |
By 9 Users
6 Excellent Ratings
|
| |
Run from Query Analyzer to find out which Service Pack is installed. Updated now to include more versions of SQL Server 6.5 and 7.0. |
| |
