Tags » Cursors

Everything in its Right Place - Database Normalisation

Flat File Tables – Everything at Once

I’m currently working on a project to replace an Excel based filesystem with a .NET / SQL Server solution. 794 more words

Coding

Drop and Create all Foreign Keys The Elegant Way

Yesterday I posted a script that will drop all of the foreign keys in your database in a very inelegant, but super effective way. Today’s script is slightly more sophisticated in that you can print out the CREATE statements for the foreign keys before running the drop. 934 more words

T-SQL

•mustache•rainbow•red•orange•yellow•green•blue•purple•free•cursors•