SqlDbx
You are not logged in.
Pages: 1
Everybody generally enters SELECT statements in proper syntactical order. By doing so, however, intellisense cannot know which table we're selecting from unless we alias it first.
We can currently enter a statement starting with the FROM clause (kind of link you do in LINQ queries) like this:
FROM tblTable1 Select<space>
...at which point intellisense pops up with the list of fields for this table (but it is only doing so for the first field; you must press <ctrl-space> to get the intellisense field list for subsequent fields. Can you fix this for additional fields?)
Could you then, upon pressing return at the end of the row, re-order the SELECT statement so that it is in correct syntactical order for execution? (ie reorder "FROM tblTable1 SELECT Field1, Field2" to "SELECT Field1, Field2 FROM tblTable1"?
Rgds,
Allen
Offline
I like this idea. Will need to think about how to implement it
Offline
Pages: 1