How can we help you today? How can we help you today?

Aliases not working when setting variable

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!
M. Haar
0

Comments

5 comments

Sort by
  • Aaron L
    Hi M. Haar,

    Thanks for your suggestion! Hopefully this is a simple improvement to make so I'll look into implementing it now :)
    Aaron L
    0
  • Aaron L
    We've just released a Prompt 6.5 beta which I've included your suggestion in. You can find out more and download the beta from this forum post.

    Please let us know if it works for you!

    Aaron.
    Aaron L
    0
  • M. Haar
    Hi Aaron Law,

    Thanks for the quick response and even quicker resolution! I will install the update this evening and will let you know if that worked for me.

    Marco.
    M. Haar
    0
  • M. Haar
    Hi Aaron Law,

    Just wanted to let you know the fix works! :D

    Thanks!

    Marco.
    M. Haar
    0
  • Aaron L
    Awesome! Thanks Marco! :)
    Aaron L
    0

Add comment

Please sign in to leave a comment.