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

Different completion behaviour

Hello,

I noticed that SQL Prompt has a different completion behaviour on a simpel query:

SELECT FROM Sales.[SalesOrderHeader]
SELECT * FROM Sales.[SalesOrderHeader] AS soh

In the first case, where there is nothing for the columns, there is no alias put automatically, while if there is a *, the alias does appear...

With kind regards,

Emmanuel
nanchen
0

Comments

1 comment

Sort by
  • Tilman
    Hi Emmanuel,

    In general, the more valid your SQL is, the better Prompt works. So I'd advise you to always put the '*' and then replace it later with a specific column list.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.