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.
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.
In the example below shows the tables in schema SalesLT. As a tooltip displays the contents of the active table.
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.
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.
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.
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".
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.
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.
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.
Via the menu (Goto and Goto previous next) or Ctrl + Alt + arrow up / down arrows, you can then move between declarations.
Menu options Goto declaration (alt press ctrl + b) moving the focus from the use of a table alias to it was declared.
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.
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 ()".
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.
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.
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.