Options

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.

Like:
DECLARE @PersonID INT

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

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

Comments

Sign In or Register to comment.