| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 AUTOSTART SQL Server setting using SQL-DMO | SQL Server 7.0 | Advanced /
Umachandar | 8661 since
7/23/2000 2:22:41 PM | Unrated
|
| |
How to the AUTOSTART SQL Server setting using SQL-DMO. This example can be extended to change any registry setting for SQL Server, SQLServerAgent, and SQLMail services. |
| |
| |
| |
|
baanwho.shar | Informix
| Beginner /
Steven Hauser | 5927 since
7/11/2000 10:45:50 PM | Unrated
|
| |
Informix/Baan, match DB session to bshell |
| |
| |
| |
|
Build a sequence via derived tables | SQL Server 7.0 | Beginner /
Michael S. Trachtenberg | 5469 since
6/15/2002 10:41:47 AM | Unrated
|
| |
Ever need a sequence? Back in the bad old days, I sometimes generated them with VB and stuck them in a table. A Cartesian product-powered View works much better. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Business Entity Class Generator | SQL Server 2000, SQL Server 7.0 | Intermediate /
Leon Tayson | 18118 since
1/13/2006 8:10:56 PM |
By 9 Users
9 Excellent Ratings
|
| |
This SP accepts a database object name (table, view) parameter and generates (C# code) custom entity class based on the object's fields. You can then copy and paste the generated code to your C# class. (ScreenShot) |
| |
| |
| |
|
Byte Size Function | SQL Server 2000 | Beginner /
Bradley Morris | 4816 since
7/9/2003 1:29:31 PM | Unrated
|
| |
This function will convert from one byte unit of measure to another. E.g. pass in 6237976 KB and request MB back, it will return 6091.7734 |
| |
| |
| |
|
Calculate mod10 | SQL Server 2000, SQL Server 7.0 | Beginner /
Svartis | 3398 since
1/30/2006 12:27:01 AM | Unrated
|
| |
Calculate mod10 |
| |
| |
| |
 |
 Changing desktop background from SQL | SQL Server 2000 | Intermediate /
Dino Scarcella | 6733 since
5/16/2008 12:38:57 PM |
By 2 Users
|
| |
This article demonstrates how one can change the desktop background in windows using xp_cmdshell.
I used this example just to show how one can modify the registry from Microsoft SQL Server.
Remember to run these two lines in the "master" database |
| |
| |
| |
|
Check Digit for EAN13 Barcode | SQL Server 2000 | Intermediate /
Conradude | 7855 since
8/27/2004 4:04:19 AM |
By 1 Users
|
| |
Calculates the Check Digit for a EAN13 Barcode |
| |
| |
| |
|
Column Name Search | SQL Server 7.0, Other | Beginner /
Corey Lasley | 7183 since
3/7/2002 2:02:00 PM |
By 6 Users
|
| |
Searches the column names in all the user tables of a database and compares them to a search string. This is useful when you have many tables, and are looking for a specific or similar column, but cant remember in what table it resides. |
| |
| |
| |
|
Counting lines in an external text file from T-SQL.sql | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 8458 since
7/18/2000 8:53:35 AM |
By 2 Users
|
| |
How to count the number of lines in an external OS file. Will work for ASCII files only |
| |
(ScreenShot)
