Project Description

An addin to Microsoft Sql Server Management Studio 2005 and 2008 which enables the user to use intellisense with added features.

The code is in a pretty ok state function wise, but it's neither 100% complete and there are still bugs in it.

I've stopped working on this addon over one year ago, and it was time for someone else to continue my work.

 

Also, check out my KeyBinding addin on Code Project.
 

Quick manual

A window with tables, aliases, functions and SQL commands pops up when typing in text editor. In the example below, you press the point, and then got up the columns in the table. What is shown is the name of the column data type, the column can be null or not and as a tooltip on the far right appears from the table it will. What appears to the right of the list and what shows up as tooltip is dependent on the type of data displayed on the left.

clip_image002

 

In the example below shows the tables in schema SalesLT. As a tooltip displays the contents of the active table.

clip_image002[7]

To select a row in intellisense window, you can press the space, tab, enter, or get left parenthesis. The various keys have slightly different behavior. Tab and enter shooting only in a selected row, spaces, indents the selected row and type a space.

 

Help texts to functions

Many sql functions has a help text that describes the parameters of the function has. The example below shows how the command LEFT () function. The top row shows the parameters that the function takes (the one in bold is the active parameter), and what the function returns (in this example a string). Next part describes briefly the function and the last paragraph describes the current parameter bit more detail.

clip_image004

 

Expand table columns

If one of a select statement writes a table alias with trailing asterisk (*), a tooltip pops up after a while saying that pressing the Tab key expands all the columns of the table. In the example below lists the five columns from table Customer when pressing the Tab key.

clip_image006

Expand the stored procedure parameters

If a stored procedure is selected in a intellisense window, a tooltip pops up after a while saying that pressing the Tab key expands all parameters for the stored procedure. In the example below, the result uspLogError <@ ErrorLogID int (4)> after the Tab key is pressed on.

clip_image008

 

Sql error

SmarterSql is looking for a number of errors in the code written. It may be that such a schedule made ​​for a table in a FROM clause. As indicated with a wavy red line under the table name. Hover over the red line shows what is considered wrong. In the example below, the text would read: "No source table schema found".

clip_image010

SmarterSql can help to fix the problem. If you put the cursor somewhere on the red line and press alt + enter, the window pops up in the picture above. In this case there was a schedule that was adopted, and if you press enter to add the proper schema to (in this case, the result FROM SalesLT.Customer AS c). Using the alt + F12 and alt + shift + F12 moves the cursor to the next or previous sql error.

Multi insert column alias

Sql error function can also be used to add column aliases on multiple columns simultaneously. The following figure is approximately the column alias AddressID and address type and the alias is put on table customer address.

clip_image012

 

Mouse over token

When the mouse is over a table name, table alias, etc. displays a tooltip with information about the current object. In the example below, held the mouse over table customer address.

clip_image014

 

Highlight token usage

You can right click on a table alias and select highlight usage in file (alternatively press Ctrl + Shift +7) to mark where the alias is used. Yellow marker is where it is defined and green where it is used.

clip_image016

 

Via the menu (Goto and Goto previous next) or Ctrl + Alt + arrow up / down arrows, you can then move between declarations.
Goto declaration

Menu options Goto declaration (alt press ctrl + b) moving the focus from the use of a table alias to it was declared.
Rename Token

Menu options Rename Token (alt press Shift + F6) opens up a dialog where a new name can be entered. An OK button or Enter key rename alias table, and all the places it is used in the sqlsats where it is used.

clip_image018

 

Live templates

There are a number of Live templates defined. It is little short commands that, when used, expanded to a larger text. Tex expanded "ssf" to "SELECT * FROM dbo.", and "dv" expands to "DECLARE @ str varchar ()".

Ambiguous columns

If a column does not have a nickname, and this column is available in two tables from the set, must be an alias added. Alt + Enter opens a menu of the table sources that can be added.

clip_image020

 

Expand insert columns

If, after an insert command, type a parenthesis "(", a tooltip after a short while as saying that pressing the Tab key expands the columns in the table. In the example below lists the nine columns of Table error log when printed the Tab key.

clip_image022

 

Expand / minimize segments

Select kits, update rates, etc may be a small minus sign to the left of the set as if you click the minimize / expand the kit. If you hold your mouse over the row that was left is shown the rate is hidden in the minimized set.

clip_image024

Last edited Jun 11, 2011 at 6:47 PM by johsas, version 12