MS SQL Server plug-in & variable for SQL Script

valerio · Post by **valerio** » Thu Sep 17, 2009 10:22 am

Hi All;

The Plug-In "MS SQL Server" executes a SQL Script fine as long as the script ist static. Is it possible to use a Variable instead of the static text? Or is there a way to tell the Plug-In to load a script file at runtime?

Or in the worst case: do I have to write my own Plug-In?

thanks for any hint
Arno

KennethLee · Post by **KennethLee** » Thu Sep 17, 2009 10:25 am

Actually, from what I've tried, you can put in variables into the SQL script. I do so in my current install and it seems to work fine.

I use $<variable>$ within the sql script. Try that and see if it works.

valerio · Post by **valerio** » Thu Sep 17, 2009 11:10 am

SUCCESS is the result of the script!!

Thanks for your help.
Arno