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

2001-11-03

1,432 reads

Blogs

Weekly reading #15

By

SQLDay 2019 is gone. The Data Community.PL has now a new goal – it...

Last Weeks Reading (2019-05-26)

By

It was tremendously extensive week for me (a week ago) when I spent time...

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Streamlining a Power BI Solution

By Additional Articles

Comments posted to this topic are about the item Streamlining a Power BI Solution

Proverbial Tree Barking

By maverickuk82

Hi All, I'm just after a pointer really. I've had an idea. I want...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers