If you were to type in the following:
Select firstname from people
You would get intesense after you typed in the from which is as expected.
What would be nice is that if you did the same thing
Select firstname, lastname from people and then went back to add columns to your query it would popup your columns as you typed in the , this would be especially nice if you had a bunch of joins and then then you go back to put in all of your columns that you want to see in your query...
Normally I will start out a new query with
select top 5 * from table t
inner join table2 t2 on t.col = t2.col where blah blah and then run the query to make sure my query works...
Then after I know that the joins are working I will go back and add the columns that I actually want to see in the query. It would be nice for the intelesense to see my joins and offer the columns that are pertinent to my query. I often have to refer to the object explorer to find my table to help remember what exact colums are in a paticular table.
Also it would be nice to have an autocomplete for the GroupBy clause that would fill in all of the fields that were selected before the from so that when you typed by groupby it would fill in the columns
Select firstname from people
You would get intesense after you typed in the from which is as expected.
What would be nice is that if you did the same thing
Select firstname, lastname from people and then went back to add columns to your query it would popup your columns as you typed in the , this would be especially nice if you had a bunch of joins and then then you go back to put in all of your columns that you want to see in your query...
Normally I will start out a new query with
select top 5 * from table t
inner join table2 t2 on t.col = t2.col where blah blah and then run the query to make sure my query works...
Then after I know that the joins are working I will go back and add the columns that I actually want to see in the query. It would be nice for the intelesense to see my joins and offer the columns that are pertinent to my query. I often have to refer to the object explorer to find my table to help remember what exact colums are in a paticular table.
Also it would be nice to have an autocomplete for the GroupBy clause that would fill in all of the fields that were selected before the from so that when you typed by groupby it would fill in the columns