Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Aliases not working when setting variable

M. HaarM. Haar Posts: 4
edited July 14, 2017 1:58PM in SQL Prompt
When you want to assign a value to a variable with the SET option then the the table name won't get an Alias.


SET @PersonID = ( SELECT [Id] FROM [Dbo].[Person].....)

It would be great if automatic assigning of aliasses worked in these kind of situations as wel!


Sign In or Register to comment.