View all triggers
this script simply returns list of all triggers and their dependant tables in current database.Ex:Select * from rk_vAlltriggers
2004-01-08
243 reads
T-SQL
Find Overlapping Jobs
Script lists all overlapping jobs that ran on selected server within last @Hoursback hours.Basically, idea behind this is to find jobs that are running at the same time, because that might significantly slow down server, especially if you have jobs that are running during business hours. You can do the same by looking into Jobs […]
2004-01-02
1,245 reads
trim leading character from column
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.
2003-11-27
157 reads
Generating sequential numbers - the fast way
It is often necessary to generate a table with sequential numbers, up to a specified upper limit N. For small N, a simple INSERT in a WHILE loop will do. But, for large N, that solution becomes too slow. This script presents a different approach. It generates sequential numbers from the binary representation of N, […]
2004-12-30 (first published: 2003-11-24)
622 reads
Find Min/Max Values in a Set
New Author! The author tries to port a solution from Oracle and runs into a problem. Agree with the solution?
2003-11-21
11,558 reads
Convert Numeric Figures into Words
Hi guys What about a function that converts a number figure into words.This sample script is to demonstrate the procedural capabilities of SQL Server . Samples select fig2words(10) will give --Ten-- ,select fig2words(103) will give --one hundred and three -- The author uses much under utilized capability of SQL Server the recursive function calls to […]
2003-11-11
556 reads
Create CSV from column (SQL2K only)
This is a bummed version of many of the "csv creating" scripts I've seen. No need to use a temp table or loop; the string can be built with one select statement (Select @String = isnull(@String + ',','') + Column From Table)
2003-11-10
371 reads
Strip Non-numeric characters from string function
Sometimes it's necessary to strip non-numeric characters from the string, so you can convert to integer without error. Often it happens when you want to use stored procedure, especially system procedures. The output there can be already with some characters (MB, KB and such), but you want this result to be used for your own […]
2003-11-10
1,315 reads
Deleting Duplicate Rows
This article presents one technique to be used for removing duplicate rows in a table.
2003-11-07
15,249 reads
Return Column as List of Comma Seperated Values
Need a comma seperated list of a particular column in a table. This will do the trick.
2003-11-03
592 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
Forums
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers