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

79 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

94 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

415 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

440 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

929 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

386 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

164 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

909 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

281 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

285 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

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Alamat Kantor BCA KCU BOGOR Tlp:08217555651

Alamat Kantor BCA KCU Sukabumi Tlp:08217555651

Alamat Kantor BCA KCU Karawang Tlp:08217555651

Question of the Day

The SQL Server MCP Server