Introducing: TSQLMacro

Introducing: TSQLAssert

Adam Machanic — Sun, 25 Jan 2009 19:55:35 GMT

Yes, yet another introduction (although there was almost zero reaction to yesterday's introduction ).

re: Introducing: TSQLMacro

Rajib Bahar — Thu, 22 Oct 2009 15:35:20 GMT

#IFDEF(MACRO_CLASS_NAME)

TSQL_CODE_HERE

#ENDIF#

thanks for this entry... the above example is all I need to understand it's value.

re: Introducing: TSQLMacro

Bob Sather — Fri, 30 Nov 2012 17:41:21 GMT

Hello Adam, I'm a developer (C++ & Sybase SQL) based at an investiment bank in London. I'm frustrated at the lack of preprocessor-like facilities in SQL. Two questions:

1) When you mention TSQL do you mean Transact-SQL as used by Sybase?

2) Does your TSQLMacro preprocessor include an #include statement? Or do you know of one that does? I am developing interconnected stored procedures on Sybase, which may share a number of #temp tables. They will only compile if each file contains its own definition of each of the tables. If the definition of a table changes, I have to change it in all of the files. Errors are easy to make. There should be an #include statement, like in C/C++, so I only have to define a table in one place. #include would also make it possible to define the parameter set of a stored procedure in one place.

Best regards,

Bob Sather

robert.sather@credit-suisse.com

re: Introducing: TSQLMacro

Adam Machanic — Fri, 30 Nov 2012 21:42:08 GMT

Hi Bob,

SQL Server. It -might- work on Sybase, as the T-SQL dialects are relatively similar due to a shared history, but I've never tried.

As for #include, no. That's not really a macro directive, so it would be out of scope for TSQLMacro. And honestly I'm not sure how it would be implemented. It's an interesting idea, though. Is Sybase the same as SQL Server where a #temp table created in an outer scope can be referenced in a stored procedure? (And is that what you're trying to solve for?) If so, I feel your pain, but it's not a problem I've ever devoted much energy to dealing with -- except by avoiding the situation altogether whenever possible.