SQLCMD Mode & SQLCMD Variables

Toad for SQL Server
1

Hi,

I’m new to Toad & am looking for how to execute scripts on the fly that contain SQLCMD variables.

Thanks in advance for any help,

Marta

2

Hi marta.herbranson,

You can try to run it SQL Editor.

Did you get any problems?

Regards,

Michael

3

Yes, it doesn’t recognize the :SETVAR command or the variables.

Thanks,

Marta

4

Hi marta.herbranson

when you F5 to run statement which include :SETVAR command or the variables, it will show up dialog to input parameters.

variable.png
variable.png1325×636 28.6 KB

Michael