C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\SQL\Snippets\2052\Function
<?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>
</_locDefinition>
<CodeSnippet Format="1.0.0">
<Header>
<Title>select top 100</Title>
<Shortcut></Shortcut>
<Description>创建表。</Description>
<Author>Microsoft Corporation</Author>
<SnippetTypes>
<SnippetType>SurroundsWith</SnippetType>
</SnippetTypes>
</Header>
<Snippet>
<Declarations>
<Literal>
<ID>SchemaName</ID>
<ToolTip>架构名称</ToolTip>
<Default>dbo</Default>
</Literal>
<Literal>
<ID>Tablename</ID>
<ToolTip>表名称</ToolTip>
<Default>Sample_Table</Default>
</Literal>
<Literal>
<ID>column1</ID>
<ToolTip>列名称</ToolTip>
<Default>column_1</Default>
</Literal>
<Literal>
<ID>datatype1</ID>
<ToolTip>列的数据类型</ToolTip>
<Default>int NOT NULL</Default>
</Literal>
<Literal>
<ID>column2</ID>
<ToolTip>列名称</ToolTip>
<Default>column_2</Default>
</Literal>
<Literal>
<ID>datatype2</ID>
<ToolTip>列的数据类型</ToolTip>
<Default>int NULL</Default>
</Literal>
</Declarations>
<Code Language="SQL">
<![CDATA[
select top 100 * from $Tablename$
order by $column1$ desc;
-- $Tablename$
$end$]]>
</Code>
</Snippet>
</CodeSnippet>
</CodeSnippets>