Page 1 of 1

MS SQL Server plug-in & variable for SQL Script

Posted: Thu Sep 17, 2009 10:22 am
by valerio
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

Posted: Thu Sep 17, 2009 10:25 am
by KennethLee
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.

SUCCESS

Posted: Thu Sep 17, 2009 11:10 am
by valerio
SUCCESS is the result of the script!!

Thanks for your help.
Arno