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)

2007-10-23 (first published: )

3,277 reads

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)

2007-10-22 (first published: )

3,991 reads

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)

2007-10-10 (first published: )

7,108 reads

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)

2006-04-25 (first published: )

1,237 reads

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)

2006-01-19 (first published: )

1,461 reads

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)

2005-08-19 (first published: )

1,992 reads

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)

2003-10-30

461 reads

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)

2003-10-28

1,683 reads

Blogs

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

Need help to form query to get missing month data

By anuxps

I want to know what are the customers having missing month data based on...

What would cause slow disk access on an AWS EBS SQL Server? (PAGELATCHIO_SH)

By apresley

I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in...

What's Causing the Pushback with DevOps?

By Grant Fritchey

Comments posted to this topic are about the item What's Causing the Pushback with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers