Recursive Factorial Function ( n ! )
Calculates the factorials of numbers between 1 - 31.High level is 31 because maximum stored procedure, function, trigger, or view nesting level is limited to 32.
2003-10-08
654 reads
T-SQL
Haversine Calculation in User Defined Function
Uses the haversine formula to calculate distance between 2 long / lat points. This can be used with a zip code / lat and long table that are available from the census bureau or post office.The @R can be tweaked dependent on what gives you the best result (its the radius of the earth, fluctuates […]
2003-09-25
776 reads
Get Column Lists script
This is a script like Column_Gitter by Rick Bolin (RickInMesa), it differs in the fact that it does not use cursors, it optionally adds the table name, it handles UDDT (User Defined Data Types) properly, and handles the new SQL Server 2000 datatypes.Usage: Open this script in QA, Change QA to the desired Database, Edit […]
2003-09-24
722 reads
2003-09-08
582 reads
Replace Mult Instances of a Pattern in a String
This function takes a pattern to be searched for, a string that the pattern will be removed from and a flag to determine whether all instances of the pattern should be removed.This is sort of an expanded version of a function I wrote to remove multiple spaces from a string.
2003-08-20
186 reads
Column_Gitter Part Deux
This script is similar to Column_Gitter. I noticed this script and wanted to present the same output without the use of cursors. Both scripts work well and produce the same results. This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names […]
2003-08-14
95 reads
ISINTEGER function
This function is similar to the ISNUMERIC native function, but tests for a valid integer. ISNUMERIC can return false positive results when testing for a valid integer. For example this select returns a value of 1 (true):select isnumeric('3d8')For 6.x and 7.0, you can easily convert it to a procedure.
2003-08-14
3,048 reads
Split String and return a table of results
Takes a simple string of delimited values, and returns a table type of the values stripped out. This can be easily incorporated in existing SQL statements utilising standard joins. Classic example of a UDF returning the TABLE data type.
2003-08-10
429 reads
Script to Create a ProperCase Function
Purpose: To create a User Defined SQL Function that can convert a string into a Proper Case string.Installation: Run the Create Function First then run the Alter Function Statement directly after.
2003-08-07
201 reads
Getting Information about Database Objects
It is sometimes necessary to have information regarding the database objects like stored procedures and triggers for e.g. we need to get information about a stored procedure like what paramters it has and so on.The sp_help system stored procedure comes in handy.What this store procedure does is that it returns result set. The result will […]
2003-08-07
191 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers