| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A Script To Get Database Info | SQL Server 2000, SQL Server 7.0 | Beginner /
DOAN Hong Ha | 17654 since
11/12/2004 8:49:14 PM |
By 5 Users
2 Excellent Ratings
|
| |
To get all information about current database.
(TableName, FieldName, Type, Length, NULLable, Refer, and more ...)
It's usefull when you want to compare 2 versions (old & new) of a database. Because while you develop an application you can change database ...(description truncated) (ScreenShot) |
| |
| |
| |
|
 A search or find using optional parameters | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Andrew Corley | 21216 since
8/6/2003 9:47:25 AM |
By 1 Users
|
| |
This stored procedure demonstrates how to create a search that accepts multiple optional parameters. Only parameters that are provided with values will be used to filter the results. This is useful for dynamic searches when the user selects or provides va ...(description truncated)(ScreenShot) |
| |
| |
| |
|
 Access 2000 Tabular Form - Building a Query Command Function | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Beginner /
davepamn | 15799 since
8/23/2002 3:51:40 PM |
By 2 Users
|
| |
Overview: Suppose you have an Access 2000 tabular form,
meaning each row is a record. Suppose you want
to have the ability to input filter criteria from the form
and press a query button for the filter to apply. This
article explains how to create this f ...(description truncated) |
| |
| |
| |
|
Add time values | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 18064 since
7/29/2000 9:47:43 PM | Unrated
|
| |
How to add time values formatted as hh:mm & display as hh:mm |
| |
| |
| |
 |
Advanced Crosstab Query | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
Sukrisno | 11836 since
2/13/2007 10:51:20 AM |
By 1 Users
|
| |
halo friends, i have some scripts for you.
the case like this, for example,
you have 2 tables, students and countries.
students have id, name, year of start and country id,
countries have id and name.
if you wanna to see the students distribution group b ...(description truncated)(ScreenShot) |
| |
| |
| |
|
Airport Database | Oracle | Intermediate /
Jim Ellis | 27652 since
12/14/2001 4:02:39 PM |
By 15 Users
9 Excellent Ratings
|
| |
Database |
| |
| |
| |
|
all query | SQL Server 2000 | Beginner /
buddha tamang | 5149 since
7/3/2009 6:47:01 PM | Unrated
|
| |
to use query option from sql |
| |
| |
| |
|
aNother way to do NOT IN queries | Oracle | Advanced /
Eli Leiba | 15115 since
2/3/2002 8:39:20 AM |
By 9 Users
5 Excellent Ratings
|
| |
This code is a transformation for NOT IN queries |
| |
| |
| |
|
 Antique Lure Database | Oracle | Beginner /
Rockwell | 6839 since
5/5/2005 9:24:59 PM | Unrated
|
| |
Hers's an antique lure database I did in a graduate class in college. |
| |
| |
| |
|
Auto Increament | SQL Server 2000 | Beginner /
Aamirr | 11669 since
3/31/2005 1:25:03 PM |
By 1 Users
|
| |
INSERT Query With SELECT Query Auto Increament |
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
