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

WHERE clause inconsistency

First, type in:
select * 
FROM [Sales].[SalesOrderDetail] sod
where

Hit space, and you get a list of columns from SalesOrderDetail. Good.

But what if I want to do the WHERE clause before the SELECT list?
select
FROM [Sales].[SalesOrderDetail] ssr
where

Now I once again get my favorite list: Every database object. Whether or not I have columns in the SELECT list, I'd like to be able to work with the WHERE clause in a manner that makes sense.
amachanic
0

Comments

1 comment

Sort by
  • Lionel
    Thanks again for the feeback. Again this looks like a bug with the error detection in the parser. I have stuck it into our bug tracking database so it should be fixed before the final release.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.