| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Access 2000 Calculating Working Days | SQL Server 2000 | Intermediate /
davepamn | 24876 since
10/3/2002 12:30:35 PM |
By 5 Users
2 Excellent Ratings
|
| |
This article explains how to use Access 2000 date functions when determining 1) the number of work days representing an interval between two dates 2) the projected end working date calculated from a start date and number of hours worked.
|
| |
| |
| |
 |
Access 2000: Controlling Report Data | SQL Server 2000, SQL Server 7.0 | Beginner /
davepamn | 20854 since
11/25/2011 5:24:54 PM |
By 5 Users
4 Excellent Ratings
|
| |
It is often the case a developer will need to create an Access 2000 reports application capable of data selection. For example, all transactions for a member. The data is input as parameters with in a form and passed to the report as query criteria. This ...(description truncated) |
| |
| |
| |
|
 Alias Table Names | SQL Server 7.0 | Beginner /
DECIS | 23082 since
12/11/2000 11:22:12 AM |
By 2 Users
|
| |
I came across a problem where the application designed would only allow SQL to run with a limited amount of characters, I simply used table aliases to cut down on the number of characters, but was told to include the table names in the field specification ...(description truncated) |
| |
| |
| |
|
Column Descriptions | SQL Server 2000 | Intermediate /
John C Kirwin | 9524 since
3/14/2007 8:24:06 AM |
By 4 Users
3 Excellent Ratings
|
| |
A great way to keep track of the original intent of the developer is to add descriptions to columns of the tables in your database (see below using Enterprise Manager). This little query can assist with documentation and training at a later date. Enhance ...(description truncated) (ScreenShot) |
| |
| |
| |
|
 connection | Oracle | Beginner /
sukusnairss | 11185 since
2/6/2004 10:47:07 AM |
By 1 Users
|
| |
browsing oracle table in MSHflex grid and also,updatingit |
| |
| |
| |
|
Count Row - one by one | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Israel Balderrama | 29215 since
3/24/2004 10:05:50 AM |
By 7 Users
4 Excellent Ratings
|
| |
This small code helps you to do a query that count all rows, using the statement COUNT. Is very easy and simple, but maybe could be very useful.(ScreenShot) |
| |
| |
| |
|
Delete Duplicated Rows in one query, simple and easy | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Intermediate /
mid.net | 12562 since
4/4/2005 6:02:54 PM |
By 5 Users
3 Excellent Ratings
|
| |
Delete duplicated Rows width have an Identity (unique) Column |
| |
| |
| |
|
Drop connections | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Zoltan Tamas, Toth | 15379 since
5/29/2002 4:38:22 AM |
By 8 Users
5 Excellent Ratings
|
| |
PLEASE VOTE! This script drops all connection of a database. If you have installed SQL 2k client tools, you must copy this script to:
..\Program Files\MS SQL Server\80\Tools\Templates\Query Analyzer\Drop_Connection.tql!
Then you can use this template anyt ...(description truncated) |
| |
| |
| |
|
Easy travel SQL logins | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Zoltan Tamas, Toth | 12625 since
6/17/2002 6:05:29 AM |
By 6 Users
3 Excellent Ratings
|
| |
***PLEASE VOTE!*** Script logins from an SQL Server with this query, and run the result script on the destination SQL Server to copy logins. |
| |
| |
| |
|
Ext js type Accordian with jquery | Other | Intermediate /
UI Champ | 3270 since
10/27/2010 8:00:33 PM | Unrated
|
| |
The peace of code is helpful for understanding the concept of accordion using jquery(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
