Technical Article

Update Foreign Key References

This script updates all foreign key references for the specified table. Useful if you need to delete a row. The follow example would update all uses of TableA.IDENTITYCOL where the value is 1 to the value of 2. Example usage: EXEC usp_updateFK 'TableA', 1, 2

You rated this post out of 5. Change rating

2001-11-03

1,460 reads

Blogs

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files?

By

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

Happy Thanksgiving! (USA Holiday)

By

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Read the latest Blogs

Forums

Don't Let Corner Cases Drive Your Design

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Don't Let Corner Cases Drive...

A New Operator

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A New Operator

Troubleshooting Common SQL Server Errors: 823, and 824

By Nisarg Upadhyay

Comments posted to this topic are about the item Troubleshooting Common SQL Server Errors:...

Visit the forum

Question of the Day

A New Operator

In SQL Server 2025, what does this code return?

SELECT '1' || '0'
 

See possible answers