| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Get amount concurrent users who are connected to one database | SQL Server 2000, SQL Server 7.0 | Intermediate /
_RayDance_ | 5502 since
5/7/2003 7:20:48 AM |
By 5 Users
2 Excellent Ratings
|
| |
For some applications you want to know the amount off concurrent users who are connected to your database or to a specific database. When you can get the amount concurrent users you can make a License for your application for which you can say: - There is ...(description truncated) |
| |
| |
| |
|
 Get environment variable in MS-SQL | SQL Server 2000 | Intermediate /
Karabunga | 5418 since
10/25/2003 4:51:36 PM |
By 2 Users
|
| |
It is now possible to get any environment variable through SQL with this simple stored procedure. Unfortunately, there is apparently no "cleaner" way to do it. Enclosing the plumbing in a stored procedure surely cleans it up a little.
|
| |
| |
| |
|
Get Executing SQL statement | SQL Server 2000 | Intermediate /
Kevin Xiong | 6175 since
2/23/2004 1:40:50 PM | Unrated
|
| |
Get executing sql statement from sql server |
| |
| |
| |
|
Get Table Depends | SQL Server 7.0 | Advanced /
Patrik Dahlen | 5541 since
1/18/2002 3:36:52 AM |
By 3 Users
|
| |
This file will get all tables and their depending
stored procedures from an SQL Server database
and display them. It will only display those
tables that have stored procedures calling on
them.
I use this to get a quick overlook during
the development phas ...(description truncated) |
| |
| |
| |
|
get the result from a table as comma seperated string | SQL Server 2000 | Intermediate /
harshal mistry | 4443 since
6/4/2003 12:03:19 PM |
By 4 Users
2 Excellent Ratings
|
| |
This procedure returns the result as a comma seperated value. it can be converted to an udf to get a column listed as a comma seperated single string. |
| |
| |
| |
|
GetStoredProcedureSizeInBytes | SQL Server 2000 | Beginner /
Luis Salgado | 2799 since
1/11/2009 9:18:22 AM | Unrated
|
| |
This code returns the size in Bytes from another stored procedure |
| |
| |
| |
|
Google Display | SQL Server 2000 | Advanced /
chandra sekhar | 5725 since
10/22/2003 11:36:09 AM | Unrated
|
| |
searches a keyword in a text column and displays as a google search format |
| |
| |
| |
|
hierarhical sorted select | SQL Server 2000 | Intermediate /
Observer123 | 4816 since
2/19/2004 5:36:36 AM | Unrated
|
| |
selecting hierarhical data without recursion
(departments, discussion boards, others) |
| |
| |
| |
|
HTTP Get SProc | SQL Server 2000, SQL Server 7.0 | Intermediate /
Michael Down | 3673 since
10/16/2004 4:27:21 PM | Unrated
|
| |
This SProc similar to the FTP_Get SProc allows MS SQL Server to download a file from a website and move it to a specific path. |
| |
| |
| |
|
Implementing Full Text Search with T-SQL stored Procedures | SQL Server 7.0 | Advanced /
Eli Leiba | 7720 since
6/25/2002 6:48:01 AM |
By 2 Users
2 Excellent Ratings
|
| |
Enabeling Full Text search in T-SQL is usually not so "popular" as doing it with the EnterPrize Manager
So Here are the T-SQL steps you have to do in order to implement FTS in T-SQL |
| |
