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

2001-11-03

1,438 reads

Blogs

Daily Coping 20 Jan 2022

By

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

Trusting the Fine Print or connecting Azure Data Factory with Salesforce

By

(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” -...

Creating a new User-Defined Data Type–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Pivotting DateTime Fields into Columns

By Luv SQL

I have the following data: What I need is to group by the SessionId...

SSIS ForEach Loop never ends, next task executes

By alicesql

I have built an SSIS package that imports files with xml data into an...

when execute query it take 32 second to return 2 rows so how to solve slowly iss

By ahmed_elbarbary.2010

I work on sql server 2017 i face issue when run simple query it...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers