Scripts

Returns the number of times any word in comma delimeted character expression occurs within another character expression.cSearchExpression -- Specifies a comma delimeted character expression that OccursAny( ) searches for within cExpressionSearched. cExpressionSearched -- Specifies the character expression OccursAny( ) searches for cSearchExpression.OccursAny( ) returns 0 (zero) if cSearchExpression isn't found within cExpressionSearched.Example:OccursAny('the,dog','The quick brown fox […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-03

75 reads

Discuss

Search for Stored Procedures

by albie@worldrampnet

SQLServerCentral

Miscellaneous

Allows user to search for stored procedures from the sysobjects table. Returns the name of the stored procedure with sp_helptext as a prefix. Useful in development environment where developers need to look up existing stored procedures.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-02

90 reads

Discuss

UPC Code with Checksum Function()

by ThomasH

SQLServerCentral

Miscellaneous

T-SQL FunctionReturns passed 10,11 digit UPC codes with calculated checksum as 12th character.Based on http://www.mecsw.com/specs/upc_a.html

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-02

408 reads

Discuss

Set logging properties for group of DTS packages

by philcart

SQLServerCentral

Miscellaneous

This script will set the Logging properties for a group of DTS packages. To run this script stand-alone, you'll need to set 6 variables. sSvr, sDb, sUid, sPwd, iSec and sPkgMatch. If you use this script in a DTS package, you can assign the values from Global Variables. The sPkgMatch variable is used as a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-01

436 reads

Discuss

SQL Server Job Status Report

by dave_is_here

SQLServerCentral

Maintenance and Management

This script generates an HTML report on the status of all jobs on a specific SQL Server instance. The report consists of several sections: a summary report of jobs that have passed, failed, been cancelled, or whose status is unknown; a detailed report of the status of each job.The script is designed to be included […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-12-01

926 reads

Discuss

Show LF, CR , Space and Tabs in Stored Procedure

by Stevan Popovski

SQLServerCentral

Word can do that. Why SQL not? Sometimes I want to see every space, horizontal tabulation, line feed or carriage return. It can help to write well formated store procedures.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-11-28

381 reads

Discuss

trim leading character from column

by kerstin

SQLServerCentral

T-SQL

this procedure takes a character, tablename and columnname as input-parameter; on execution it removes the given leading character from the table-column - as well as leading blanks. small and easy but very helpful.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-11-27

162 reads

Discuss

Monitor space used for disks, DBs, tables and filegroups

by Steen-Molberg

SQLServerCentral

Maintenance and Management

I pieced this script together from solutions I found on this and from Brian Knight's excellent book. It creates 3 tables: - tblDriveLogs. Collects free drivespace info for each drive for each time the script is run. - tblIndexLogs. Collects info on spaceused for each index and table. Please note that when only af single […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2003-11-26

905 reads

Discuss

Truncate all tables in a database

by PaulBarbin

SQLServerCentral

Miscellaneous

This "script" truncates all user tables in a database (except dtproperties). It uses sp_msforeachtable stored procedure which cycles through each table in the database and performs the same query on each. Its useful in a number of different scenarios

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2003-11-24

275 reads

Discuss

DescribeTable

by jamie

SQLServerCentral

SQLInsider Scripts

Script displays fieldname, datatype and size.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-11-20

278 reads

Discuss

Scripts

OccursAny

Search for Stored Procedures

UPC Code with Checksum Function()

Set logging properties for group of DTS packages

SQL Server Job Status Report

Show LF, CR , Space and Tabs in Stored Procedure

trim leading character from column

Monitor space used for disks, DBs, tables and filegroups

Truncate all tables in a database

DescribeTable

Blogs

AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

Monday Monitor Tips: AI Alert Analysis

From SQL Saturday to Day of Data

Forums

Bank BCA KCU Tebing Tinggi telp 0817 844 112

Bank BCA KCU Kisaran telp 0817 844 112

Bank BCA KCU Pematang Siantar telp 0817 844 112

Question of the Day

Converting Money