Have created T-SQL based framework with following features:
1) SP and Function preprocessing (called from DDL trigger) 2) simple after cleanup mode (same like CREATE OR REPLACE in PostGres) 3) foreach pseudo block instead of manual cursor handling 4) OOP support for tables - you can define interfaces in declaration style (with methods and) with inheritance and then apply them to target table
Pure T-SQL, improved syntax used as usual T-SQL (no advanced editor or code-processing needed, no .NET assemblies).
Script is safe to use - not affected usual behavior of regular objects.
How to start: 1) create empty database 2) execute comdiv.mtsql.core.sql - generates Macro T-SQL framework 3) execute comdiv.mtsql.core.interfaces.sql - some our best practices expressed as table interfaces 4) execute comdiv.mtsql.core.example.sql - shows main features
Learn from example, then interfaces, then core. Documentation embedded to scripts.
Macro T-SQL - lang extensions (v 1.5 release)
Posted - 07/12/2010 : 23:52:53
