| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Check duplicate records in a table | SQL Server 2000 | Beginner /
Developer142 | 5212 since
7/2/2009 8:58:32 AM | Unrated
|
| |
Check duplicate records in a table |
| |
| |
| |
|
 ColDefinition or helping upsert SP writing | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Pollus Brodeur | 11606 since
9/26/2002 11:22:42 PM | Unrated
|
| |
Help programmers to easily build insert/update stored procedures. It will create almost all the TSQL code for you. |
| |
| |
| |
|
Column Rename in SQL SERVER 2005 | SQL Server 2000 | Beginner /
Developer142 | 7231 since
7/2/2009 8:58:20 AM | Unrated
|
| |
To rename a column in sql server 2005 |
| |
| |
| |
 |
Columnas Dinamicas | SQL Server 2000 | Advanced /
Marcos Perez | 4405 since
3/29/2007 6:43:51 AM |
By 1 Users
|
| |
Crear columnas en tiempo de ejecucion... |
| |
| |
| |
|
Combine Dissimilar Tables In A Single Query | SQL Server 2000, SQL Server 7.0 | Beginner /
Dave Vroman | 4049 since
6/16/2007 6:29:21 AM | Unrated
|
| |
This Query Is Used To Combine Two Category Lists Into A Single Table.
It Is Used To Facilitate Combined Data Lists In A Data Warehouse Which Services Two Different Databases For Two Associated Companies.
|
| |
| |
| |
|
Combine Multiple Like Tables | SQL Server 2000 | Beginner /
Dave Vroman | 3479 since
6/16/2007 6:29:28 AM | Unrated
|
| |
This Is A Way To Combine The Native FedEx Tables At The Query Level. Each Region Comes In A Separate Table With A List Of Regions By Zip Code As The Master Linking List
The Weight Column Is An Integer Value And The Minimum Weight Is 1 Pound.
|
| |
| |
| |
|
CONDITIONAL SEARCH | SQL Server 2000 | Advanced /
Developer142 | 3296 since
7/2/2009 8:59:03 AM | Unrated
|
| |
Recently I got a problem lkke this:
3 buttons with title "abc" ,"def","ghi"
1.if we first click on "abc" button then query must return the result for which name field begins with 'a' or 'b' or 'c' OR it contains " a"(space before a) or " b"(space before b ...(description truncated) |
| |
| |
| |
|
Count Colums | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Usman Farhat | 9428 since
6/19/2002 9:21:22 AM |
By 2 Users
|
| |
Proceudure Returns Numbers OF Colums Existed In Particular Table |
| |
| |
| |
|
create_user_procedure | Oracle | Advanced /
rachid boutat | 10387 since
2/27/2002 10:02:04 AM |
By 2 Users
|
| |
the purpose of this procedure is to create oracle users.
if the user exists, it drops him first, then it create him again and asign to him a tablespace and basic roles. |
| |
| |
| |
|
Creating a dump of XML in a text field | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
The_Mat_in_the_Hat | 11105 since
10/18/2000 5:26:21 AM |
By 3 Users
2 Excellent Ratings
|
| |
Similar to my last stuff about creating XML strings, but this time using a text field to store data of almost any length, and creating heiarchical data. This is a useful proc if you need to have data dsent out on a daily basis, and seems quite happy worki ...(description truncated) |
| |
