Effectively mapping primary key – foreign key relations
This script maps the primary key - foreign key relations regardless if the column names are the same or not.
2012-05-15 (first published: 2007-11-07)
2,848 reads
John Liu
2008-09-02 (first published: 2008-07-10)
2,658 reads
Blogs
sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Forums
Deleting duplicate records with a CTE
This code is modified from an example I saw. The purpose is to delete...
Building Your Brand
Comments posted to this topic are about the item Building Your Brand
A Little Paranoia is Good
Comments posted to this topic are about the item A Little Paranoia is Good
Ask SSC