Disable foreign keys

Ever need to disable some foreign key during the load of new data in some tables? (Eq: for a snapshot). The following just does that using a parameter (0 for disable and 1 for enable)

4 (2)

2005-08-15 (first published: )

1,238 reads

Blogs

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Daily Coping 25 Nov 2020

By

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

Database DevOps Deployment to Azure–Webinar

By

You can register now, but on Dec 3, I have a webinar with Microsoft...

Read the latest Blogs

Forums

Thanksgiving 2020

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving 2020

Thanksgiving Visualizations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving Visualizations

Practice SQL querying with dates and aggregations

By Lord Slaagh

Hello SSC! I am looking for some practice with advanced SQL querying. I have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers