Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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)
 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
38200 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  
 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.05 seconds. Powered By: Snitz Forums 2000