How can we improve SQL Prompt?

SqlPrompt doesn't understand the Syntax of an update-statement when the table-to-be-updated is aliased

Hi!

Please consider this statement

update t1
set t1.value = t2.value
from Table1 t1
join Table2 t2
on t1.ID = t2.ID

When you have the cursor in the set-block of the statement, SqlPrompt doesn't know what 't1' means and which columns t1 has.

60 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Florian WittelerFlorian Witteler shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Aaron BaumanAaron Bauman commented  ·   ·  Flag as inappropriate

        To clarify a bit: if you type in "t1." you do not get a list of the columns.
        However if you leave off the "t1" and just hit [space] after "SET" it will give you a list of the appropriate columns.
        I think it should give you the list of columns when hitting "t1"

      • Nicholas OrlandoNicholas Orlando commented  ·   ·  Flag as inappropriate

        Seems to work just fine for me. Only time it doesn't work is when there is a syntax error earlier in the query or if the table being updated is a temp table and SQL Prompt can figure out the definition of the table. EX: SELECT * INTO #MyTempTable FROM MyTable

      Feedback and Knowledge Base