| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Correlated query example | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 40886 since
7/29/2000 9:56:12 PM |
By 2 Users
|
| |
Here is one example of a correlated query. This example uses a table that contains messages for each user. This can be used to delete all but the 2 latest messages. |
| |
| |
| |
|
 COUNT ROW V2 | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Israel Balderrama | 4927 since
12/2/2004 4:46:12 PM |
By 1 Users
|
| |
This small code helps you to do a query that count all rows, now inserting into a temporary table. Is too very easy and simple, but maybe could be very useful. First, a variable table is declared, the AuthorId is identity because it'll count the rows, the ...(description truncated) |
| |
| |
| |
|
Creating and Manipulting With Virtual Table | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle | Beginner /
ManivannanUma | 8506 since
10/27/2002 1:30:22 AM |
By 4 Users
|
| |
To create and manipulte the Virtual table using SQL query.These are sometimes identified as Temprouary Table..These table could not a have any physical memeory. |
| |
| |
| |
|
Crosstab Query | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Advanced /
Sukrisno | 5925 since
2/9/2007 6:01:29 AM | Unrated
|
| |
it is very simple query to make a crosstab query. (ScreenShot) |
| |
| |
| |
|
Current Date/Periods | SQL Server 2000 | Advanced /
John C Kirwin | 3218 since
6/10/2010 9:08:54 AM | Unrated
|
| |
Query of current date and periods |
| |
| |
| |
|
Cursor days of the week | SQL Server 2000 | Advanced /
John C Kirwin | 3171 since
6/4/2010 9:01:16 AM | Unrated
|
| |
This code will cursor through the days of the week and print the day and date each time through |
| |
| |
| |
|
Custom Paging Based on Only Page Numbers | SQL Server 2000 | Beginner /
Developer142 | 3516 since
7/8/2009 3:35:31 PM | Unrated
|
| |
To demonstrate Custom Paging Based on Only Page Numbers |
| |
| |
| |
|
Days Of This Week | SQL Server 2000 | Advanced /
John C Kirwin | 2997 since
6/4/2010 9:01:01 AM | Unrated
|
| |
This query will return the day of the week in one column and the date in another column. |
| |
| |
| |
|
Deeply Nested INNER JOINs | SQL Server 7.0 | Beginner /
Tim Daniels | 67885 since
11/1/2000 12:44:10 PM |
By 6 Users
5 Excellent Ratings
|
| |
To create a large working table from four disparate tables to demonstrate nesting INNER JOINS multiple times using multiple ON criteria and multiple WHERE criteria. |
| |
| |
| |
|
Delete a user created function with system_function_schema owner | SQL Server 2000 | Intermediate /
Kevin Xiong | 4577 since
6/4/2003 3:06:25 PM |
By 4 Users
3 Excellent Ratings
|
| |
Delete a user created function with system_function_schema owner. |
| |
(ScreenShot)
