Add support for SQL CMD variables in SSDT/VisualStudio
When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.
SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
Then a becomes an "unresolved alias"
1
vote
Fredrik Rundgren
shared this idea
This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/