SSMS Code Snippets

工作上會有一些常用的查詢Sql
在SSMS可以透過Code Snippets的功能
快速輸入儲存的Sql
方法如下

1. 建立Code Snippet

新增檔案
副檔名為.snippet

<?xml version="1.0" encoding="utf-8" ?>
<CodeSnippets
	xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
	<_locDefinition
		xmlns="urn:locstudio">
		<_locDefault _loc="locNone" />
		<_locTag _loc="locData">Title</_locTag>
		<_locTag _loc="locData">Description</_locTag>
		<_locTag _loc="locData">Author</_locTag>
		<_locTag _loc="locData">ToolTip</_locTag>
		<_locTag _loc="locData">Default</_locTag>
	</_locDefinition>
	<CodeSnippet Format="1.0.0">
		<Header>
			<Title>4. 預設Select</Title>  <!-- 會顯示的Title -->
			<Shortcut></Shortcut>         <!-- 沒有用的shortcut -->
			<Description>空白的Select</Description>
			<Author>Frank</Author>
			<SnippetTypes>
				<SnippetType>SurroundsWith</SnippetType>
			</SnippetTypes>
		</Header>
		<Snippet>
			<Declarations>
				<Literal>
					<ID>2</ID>
					<ToolTip>Code to handle the caught error</ToolTip> <!-- hover時，會顯示的註解 -->
					<Default>SELECT</Default>
				</Literal>
			</Declarations>
			<Code Language="SQL">  <!-- SQL寫在這邊 -->
				<![CDATA[SELECT TOP(1000) *
FROM
WITH(nolock)
]]>
			</Code>
		</Snippet>
	</CodeSnippet>
</CodeSnippets>