How to get substitution variable in sql server

Select  &col from  employees

Open in new window


This  line  on execution in 12c  gives popup  for asking  col  substitution.
Please  can anyone give similarity  for  Sql server 2017.

I  know  @var  can be done  in stored  procedure,but I  want  popup  like  oracle 12c
ADITYA RAOSoftware DeveloperAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
No, in SQL Server we don't have any mechanism to get pop up for Variable Substitution.
We need to properly declare the variable and then assign value to the variable before executing the script.
2
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.