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

Common problem in all versions of SQL Prompt

I noticed that a less-commonly-known UPDATE syntax isn't supported by SQL Prompt.

You can alias your UPDATE statements... so this SQL (at then end of this message) actually works, but SQL Prompt isn't very helpful as you write it.

I use it all the time, would love if SQL Prompt could help!

Thanks,
Sam


update sd
set sd.Product_Name = p.product_Name
from Product as p
inner join Sales_Data as sd
on p.Product_Key = sd.product_key
sam88jeep
0

Comments

1 comment

Sort by
  • tanya
    Hello,

    Thank you for taking the time to report this issue.
    We have this logged in our bug tracking system and will have it addressed in our future version.

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.