Hello, I mainly use Toad for Oracle which allows me to embed variables within a sql statement or unioned sql statements using the prefix “&&”.
ie &&LAST_NAME. &&SCHEMA_ID &&DB_LINK
When I execute the sql statement I am prompted for the runtime value I wish to use at that particular time.
Using the double “&&” Toad for Oracle only prompts me only once even if this variable is used in multiple unioned statements(I have some statements with 8 to 10 unions).
Which is usually what I want.
I understand in Toad for sql server I can use the set command to intialize variables. But that falls short of a real runtime initialization of a variable, especially if there are many variable embedded in your sql statements.
Does Toad For SqlServer have an equivalent of the Oracle variable designation “&&” and prompt and if so what is the syntax?