แชร์ผ่าน

Locating and Scripting Templates

  • บทความ

Templates let users easily create scripts for use with Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) databases. The templates contain Transact-SQL statements that are embedded with parameter placeholders, in which you can substitute valid query values.

You can select templates from Template Browser. This organizes all available templates into categories. SQL Server Compact Edition supports the following categories in Template Browser:

  • Create Database
  • Create Index
  • Create Table
  • My Templates

After you select a template, the information for the template is displayed in the template pane within SQL Server Management Studio. Under the template pane is the Parameter Replacement Grid, where you can specify the values for template parameters and automatically apply those values to the template.