Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,204 reads
2007-12-12 (first published: 2007-10-12)
3,286 reads
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,734 reads
Blogs
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Forums
How can I show the last opening period for each project in my project dimension
I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...
Upgrading from 2016 to 2019 with Encryption
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
NOT LIKE Alternatives in WHERE clause
Hello, I need help to improve an existing (hence I cannot change table's structure...
Ask SSC