Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fagim
Starting Member
9 Posts |
 Posted - 2010-07-12 : 23:52:53
|
| 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 handling4) OOP support for tables - you can define interfaces in declaration style (with methods and) with inheritance and then apply them to target tablePure 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.Project:[url]http://code.google.com/p/macrotsql/[/url]Blog:[url]http://mt-develop.blogspot.com/[/url]Wave:https://wave.google.com/wave/waveref/googlewave.com/w+zLyWVnrHADoc and examples:included in sql scripts in source codeQuickly can download here:[url]http://macrotsql.googlecode.com/files/comdiv.mtsql.current.zip[/url]How to start:1) create empty database2) execute comdiv.mtsql.core.sql - generates Macro T-SQL framework3) execute comdiv.mtsql.core.interfaces.sql - some our best practices expressed as table interfaces4) execute comdiv.mtsql.core.example.sql - shows main featuresLearn from example, then interfaces, then core. Documentation embedded to scripts. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
fagim
Starting Member
9 Posts |
Posted - 2010-07-16 : 02:45:06
|
| Start page of [url]http://code.google.com/p/macrotsql/[/url] rewrited, first realease (1.5v) published.Start page now contains all well-formed examples of syntax and features provided by project. |
 |
|
|
|
|
|
Macro T-SQL - lang extensions (v 1.5 release)