Pinned

1. sp_CRUDGen sp_CRUDGen Public

   sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types. The generated stored proced…

   TSQL 52 8

2. sp_Develop sp_Develop Public

   Forked from EmergentSoftware/SQL-Server-Development-Assessment

   sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.

   TSQL

3. SQL-Server-Temporal-Table-Changes-Get SQL-Server-Temporal-Table-Changes-Get Public

   Forked from EmergentSoftware/TemporalTableChangesGet

   This stored procedure exists to return results of column values that have changed from a Temporal table (also known as system-versioned temporal table). It generates dynamic SQL and either executes…

   TSQL

4. Date-Time-Number-Dimension Date-Time-Number-Dimension Public

   Forked from EmergentSoftware/Date-Time-Number-Dimensions

   SQL Server T-SQL scripts to create the data warehouse dimensions or business intelligence tables and load the tables with data.

   TSQL

5. SQL-Server-Database-Development-Best-Practices SQL-Server-Database-Development-Best-Practices Public

   Forked from EmergentSoftware/DBBestPractices

   A novella size of SQL Server database best practices, all for free.