SQL

Scripts, tools and tips for SQL databases (primarily SQL Server).

Jul 27 2021

SQL Server Script to search for a value across all tables and columns

Aug 19 2020

SQL Server script to create a database, login, user and permission

Aug 18 2020

SQL Server Script to magically cascade delete rows from table and foreign key relationships

Aug 17 2020

SQL Server script to automatically create indexes for foreign keys