I am trying to reproduce the substitution variables that work well for Oracle. ie.
Select &fieldname as ‘&fieldname’ from &tblName
Select lastname, ‘lastname’ from Employees
In SQL Server I would expect the following to work but it does not. The colon only seems to work as a value not a column or table name
Select :fieldname as ‘:fieldname’ from :tblName
Thanks for any direction you can provide