SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 Macro T-SQL - lang extensions (v 1.5 release)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

fagim
Starting Member

Russia
9 Posts

Posted - 07/12/2010 :  23:52:53  Show Profile  Reply with Quote
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:
http://code.google.com/p/macrotsql/

Blog:
http://mt-develop.blogspot.com/

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:
http://macrotsql.googlecode.com/files/comdiv.mtsql.current.zip

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.

Edited by - fagim on 07/16/2010 02:47:09

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 07/13/2010 :  00:31:40  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Russia
9 Posts

Posted - 07/16/2010 :  02:45:06  Show Profile  Reply with Quote
Start page of http://code.google.com/p/macrotsql/ 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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000