Technical Article

Find Table Usage

Creates a printable report of all stored procedures, views, triggers and user-defined functions that reference any of the tables passed into the procedure.Wrote this to easily list items affected by table changes when working in a fast-paced development environment developing a shrink wrapped product undergoing many schema changes.Split function is listed after sp definintion

3 (6)

You rated this post out of 5. Change rating

2007-10-23 (first published: )

3,296 reads

Technical Article

Find Column Name Usage

This procedure produces a formatted report to list which tables, views and table functions have a column of the specified name. This is particularly useful in systems that do not enforce referential integrity or when schema changes are being evaluated.

4.17 (6)

You rated this post out of 5. Change rating

2007-10-22 (first published: )

4,133 reads

Technical Article

Find Column Usage

When changing schema or modifying an application it is often necessary to determine when a column from a specific table is used.  This procedure produces a formatted report (when outputting from query analyzer or management studio in text mode) that specifies all of the procedures, views, functions and triggers that use the designated table.column.

5 (13)

You rated this post out of 5. Change rating

2007-10-10 (first published: )

7,376 reads

Technical Article

Determine Distance Between Any Two Locations

This function allows you to calculate the distance in miles or kilometers between any two points on the earth. I created to calculate the distance between two zip codes but is can be used for any two coordinates for which latitude and longitude is known.NOTE: A database for the coordinates of any US postal code […]

5 (4)

You rated this post out of 5. Change rating

2006-04-25 (first published: )

1,256 reads

Technical Article

Calculate upcoming business day from date (Updated)

Calculates the next business day based upon the work weeklength, number of days from the start date and a list of holiday dates kept in a table called HolidayDate.Created this script for determining the next banking day from 2 days after a request for wiring funds. Can be used for things like calculating shipping dates […]

5 (1)

You rated this post out of 5. Change rating

2006-01-19 (first published: )

1,516 reads

Technical Article

Pad String

Pads a string on either with either leading or trailing characters. You specify the direction, the tolal string length and the character to pad with.Error conditions return null

5 (2)

You rated this post out of 5. Change rating

2005-08-19 (first published: )

2,034 reads

Technical Article

Check if IP address is in private IP range

Function to allow for checking if an IP address is a private IP address.  Will convert the IP to a bigint equivalent if within the private range, otherwise it will return null if IP is a public address.Requires function IPStringToNumber which is included in the post

5 (1)

You rated this post out of 5. Change rating

2004-01-23

1,238 reads

Technical Article

Join Column Values

This script will join a single selected column from a select statement into a varchar variable. This works similarly to the javascript join function with a few additional features. By default the values will be joined with commas unless an alternate delimiter is supplied. The user can specify if the delimited values should quoted. To […]

5 (1)

You rated this post out of 5. Change rating

2003-10-30

518 reads

Technical Article

Identify Primary Key Violation Prior to Insert (Updated)

This script allows for testing if rows will cause a primary key violations prior to inserting the data.  Offending rows are stored in a table so they can be used in subsequent queries or used to debug bad data issues. This updated version adds a timestamp to the duplicates table so that identifying when the […]

4 (2)

You rated this post out of 5. Change rating

2003-10-28

1,808 reads

Blogs

How to Convert FileTime to DateTime

By

One of my customers recently wanted to rename each of the SQL audit files...

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Read the latest Blogs

Forums

SQL estate future planning

By goodtimecharlie

Morning all, I've inherited a small (on prem) SQL estate.  I'm a DBA, used...

Error sub query return more than one value

By reza.asali

insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join SecurityKms8081..Import_users_barghGharb i2 on i2.code_personeli=u2.PersonnelNumber...

How to change font size in Query window

By MurraySobol

I am running SQL Server 20.2. When I copy a query into the query...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers