Detect and Repair Non Trusted Foreign Keys
Create the code to detect and repair non trusted foreign keys
2018-11-13 (first published: 2018-09-27)
425 reads
foreign keys
Using Super Keys to Enforce Database Constraints
Example of Using Super Keys to Enforce Database Constraints, instead of procedural code
2017-08-07
2,214 reads
Truncate a table that has foreign keys referencing its columns
This stored procedure will truncate a table even when other tables have FKs referencing columns in it. It drops the Fks, truncates the table, re-creates the FKs
2017-04-19 (first published: 2017-03-28)
695 reads
Truncate tables with foreign keys
Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !
2016-12-01 (first published: 2016-11-28)
1,118 reads
RE: selecting max of 2 records per account
Alright. I may be going around the barn to get to the horse, (or however the saying goes), but this seems to work. Hopefully, someone will figure out a more elegant and streamline method. CREATE TABLE #u_external_requests( acct_number int, idx int, stage int) INSERT INTO #u_external_requests VALUES( 1000000179, 1, 7) INSERT INTO […]
2005-05-05
replacing commas in a table field
I am using SQL server 2000 and have a table , in which one of the fields has multiple commas that need to be removed.An eg. of the field is CR 12,455I tried the following:Update TABLE set field = replace(field,'[,]','')and the result said that it had updated all the rows , but there had been […]
2005-05-05
8 reads
RE: How View ALL Transaction Log from a database
Once the log either be backed up (Full Recovery Mode) or truncated (Simple Recovery Mode), Only the active transactions and committed transactions since last log backup or checkpoint are in the log file.
2005-04-28
OTAP Priviliges (eg MSDB, MAster)
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-02-04
RE: Identity field as a key
Use Int Identities where you can. Make them a primary key, and build a proper relational database with enforced foreign keys and then you wont have data integrity issues. If your entity has an attribute that is unique: create a Natural Key. Using ISBN as the key wouldn't be a good idea if its repeated […]
2005-01-18
RE: Strip Non-Numeric Characters from Varchar
Okay, next time we have a sophisticated discussion at the lowlands of a language, it should be in German. I'll stick to my school english and avoid slang.
2005-01-12
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers