| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A SQL Create Table with Calculated Columns | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Beginner /
Duane Warsham | 12176 since
1/30/2009 8:29:24 AM |
By 1 Users
|
| |
Code will calculate and populate other columns in your table on every data row insertion. This coding example was coded in SQL Server 2005. |
| |
| |
| |
|
 Basic Application Design for System Adminstration | SQL Server 7.0, Informix
, Oracle, Other | Beginner /
Steven Hauser | 20821 since
7/11/2000 10:58:05 PM |
By 6 Users
|
| |
As a system administrator I have seen many "off the shelf" applications and in house applications that have basic administration problems. Some are just plain bad design that make the application hard to administer. Here are some tips. |
| |
| |
| |
|
Construct your Own create table script | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Eli Leiba | 27285 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 |
| |
| |
| |
|
Create T-SQL Cursor Code For any Table | SQL Server 2000, SQL Server 7.0 | Advanced /
Limbo | 40158 since
3/9/2003 3:19:39 PM |
By 9 Users
7 Excellent Ratings
|
| |
Got tired of hand coding all that T-SQL cursor code so I created this to create the shell template for me.
Just choose any table you want to create a template for to process the records using a cursor. |
| |
| |
| |
|
Creating Objects in ORACLE | Oracle, Other | Beginner /
Md. Tanzim Saqib | 12879 since
4/18/2005 2:37:09 PM |
By 2 Users
|
| |
This code will teach you how you can create and use objects in ORACLE. First you have to create an object. After creating object put it into a table to use it. Then insert some data and query by the SELECT statement. See code for 100% clarification. |
| |
| |
| |
|
Custom time format (+ verify with check constraint) | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 11421 since
7/27/2000 9:10:53 PM |
By 2 Users
|
| |
Define a column with a custom time format & verify validity of data using CHECK constraint. |
| |
| |
| |
|
Easy Drop and ReBuild Constraints with an SP | SQL Server 7.0 | Advanced /
Zoltan Tamas, Toth | 11758 since
4/15/2002 6:21:06 AM |
By 1 Users
|
| |
This code is generating an SQL script, that drop or build referentials. |
| |
| |
| |
|
Got constraints? ERP does not. | SQL Server 7.0, Informix
, Oracle, Other | Beginner /
Steven Hauser | 11131 since
7/11/2000 11:08:28 PM |
By 2 Users
|
| |
The question of database level enforced constraints vs programmer applied constraints is asked occasionally by people who have not done much database development work.
|
| |
| |
| |
|
Hot Data Dictionary | SQL Server 2000 | Advanced /
Raghavendra Narayana Upadhya | 7029 since
1/14/2008 8:37:51 AM |
By 1 Users
|
| |
Simple query to get the Data Dictionary within seconds for data modeling study purpose. Compatible with SQL Server 2005 and 2000. (ScreenShot) |
| |
| |
| |
|
Organise your SQL! | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Tony Cheetham | 16385 since
12/11/2000 9:01:16 AM |
By 6 Users
|
| |
Having trouble organising your SQL tables? Do you have to keep a hard copy of all your SQL tables because you cant remember column names? This article will help you.(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
