問題描述
在 SQL Server Management Studio 中表的上下文菜單中，公共項 Script Table as 下有幾個項目:
In the context menu of a table in SQL Server Management Studio there are several items under the common item Script Table as:
SELECT to
INSERT to
UPDATE to
DELETE to
..
并且對于所有對象都相同，例如存儲過程、函數(shù)等
and the same for all objects, e.g. stored procedures, functions, etc.
如何編輯該菜單使用的模板?
How can I edit the templates used by that menus?
推薦答案
您無法編輯 SQL Server Management Studio 使用的模板(這將是一個不錯的功能).
You cannot edit the templates used by SQL Server Management Studio (which would be a nice feature).
您可以在 C:\Users\Username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql(對于 SQL Server2008)
You can create your own (parameterised templates) in C:\Users\Username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql (for SQL Server 2008)
這篇關于如何將 SSMS 腳本表編輯為模板?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！