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.

 All Forums
 General SQL Server Forums
 Script Library
 Macro T-SQL - lang extensions (v 1.5 release)

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 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.

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+zLyWVnrHA

Doc and examples:
included in sql scripts in source code

Quickly can download here:
[url]http://macrotsql.googlecode.com/files/comdiv.mtsql.current.zip[/url]

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.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-13 : 00:31:40
Sorry fagim, I fixed it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -