sql prompt

sql search对于新建的数据库或数据表无法智能提示

选择sql prompt菜单，然后子菜单refresh suggestions

 

sql server自带的智能提示刷新

 https://stackoverflow.com/questions/7825287/sql-server-how-to-refresh-the-intellisense

 

If you want to do it via the menus, it's:

Edit / IntelliSense / Refresh Local Cache

Using the keyboard, it's: CTRL-SHIFT-R

 

tab feature(different server with different tab colors)

右键选中某一个数据库，然后选择Tab color

 

Style定制

这个style会影响到Format SQL这个功能

 

Speeding up your queries

Managing snippets

 A SQL Prompt snippet is a block of code you can insert into your query. To insert a snippet, type the snippet name (eg ssf) into your query and press Enter or any other insertion key:

Snippet Manager

To see the list of snippets you can use, go to the SQL Prompt menu and select Snippet Manager. You can find specific snippets by searching for both name or description:

 

 

<activationrequest>
  <version>3</version>
  <machinehash>4F4B-A732-F619-E4BF</machinehash>
  <productcode>13</productcode>
  <majorversion>10</majorversion>
  <minorversion>0</minorversion>
  <serialnumber>A32E-DKGR-R8J4-FFBB-FK22-JCW9</serialnumber>
  <session>6e7fb861-cafe-5f55-344b-a18ca63cb088</session>
  <locale>zh-CN</locale>
  <anonymous>false</anonymous>
  <authorizationtoken>3265cda2-1bd4-8b6e-f804-02c7bd37e7fe</authorizationtoken>
  <custom />
</activationrequest>