推荐: SQL Server Management Express Edition插件

谁借莪１个温暖的怀抱￠ 2021-12-14 00:57 123阅读 0赞

如果使用SQL Server2005的Express版本时，不可避免需要使用SQL Server Management  Express Edition。而2005版本之前的管理器中书写SQL、查找字符、格式化SQL等都觉得不好使。这两天网上看到了两个工具，可以加强SQL Server Management  Express Edition的功能。  
1 Red Gate的SQL Prompt。可以看一下blog   
[www.cnblogs.com/jintan/archive/2008/06/15/1220365.html][www.cnblogs.com_jintan_archive_2008_06_15_1220365.html]  
2 ssmstoolspack  
[http://www.ssmstoolspack.com/][http_www.ssmstoolspack.com]  
It contains a few upgrades to the IDE that I thought were missing from the Management Studio:

*  [Uppercase/Lowercase keywords.][Uppercase_Lowercase keywords.]
 *  [Run one script on multiple databases.][]
 *  [Copy execution plan bitmaps to clipboard.][]
 *  [Search Results in Grid Mode and Execution Plans.][]
 *  [Generate Insert statements for a single table, the whole database or current resultsets in grids.][Generate Insert statements for a single table_ the whole database or current resultsets in grids.]
 *  [Query Execution History (Soft Source Control).][Query Execution History _Soft Source Control_.]
 *  [Text document Regions and Debug sections.][]
 *  [Running custom scripts from Object explorer's Context menu.][Running custom scripts from Object explorer_s Context menu.]
 *  [CRUD (Create, Read, Update, Delete) stored procedure generation.][CRUD _Create_ Read_ Update_ Delete_ stored procedure generation.]
 *  [New query template.][]

在Vista安装时可能出现：外接程序“SQL Server Management Studio Express Tools Pack”未能加载或导致了异常。错误号: 80040154。  
解决：使用setup.exe安装，所有用户环境下使用。

转载于:https://www.cnblogs.com/zhoujg/archive/2008/06/15/1222625.html

[www.cnblogs.com_jintan_archive_2008_06_15_1220365.html]: http://www.cnblogs.com/jintan/archive/2008/06/15/1220365.html
[http_www.ssmstoolspack.com]: http://www.ssmstoolspack.com/
[Uppercase_Lowercase keywords.]: http://www.ssmstoolspack.com/Features.aspx#FKW
[Run one script on multiple databases.]: http://www.ssmstoolspack.com/Features.aspx#RMS
[Copy execution plan bitmaps to clipboard.]: http://www.ssmstoolspack.com/Features.aspx#CEP
[Search Results in Grid Mode and Execution Plans.]: http://www.ssmstoolspack.com/Features.aspx#SRE
[Generate Insert statements for a single table_ the whole database or current resultsets in grids.]: http://www.ssmstoolspack.com/Features.aspx#GIS
[Query Execution History _Soft Source Control_.]: http://www.ssmstoolspack.com/Features.aspx#SSC
[Text document Regions and Debug sections.]: http://www.ssmstoolspack.com/Features.aspx#RDS
[Running custom scripts from Object explorer_s Context menu.]: http://www.ssmstoolspack.com/Features.aspx#RCS
[CRUD _Create_ Read_ Update_ Delete_ stored procedure generation.]: http://www.ssmstoolspack.com/Features.aspx#CRUD
[New query template.]: http://www.ssmstoolspack.com/Features.aspx#NQT