Without fully specifying the join condition, just listing the tables as above allows intellisense to work with a. The next thing you need to get used to is to write your queries in a different order, fill in the FROM clause first, so the skeleton should be something like SELECT ^Īt the position marked ^, intellisense will have a good idea of what db/table context you are working in. This gives it a better grasp of where you are working. The first thing you can to do make it recognize the database context is to put USE databasename Īt the top of your query window. It is a fine art making intellisense work for you. First and foremost you must be working with a SQL Server 2008+ instance, for the server to be able to give you the metadata for intellisense.
0 Comments
Leave a Reply. |