Applies to: SQL Server Azure SQL DatabaseOverviewThis sample showcases the In-Memory OLTP feature. It shows memory-optimized tables and natively compiled stored procedures, and can be used to demonstrate performance benefits of In-Memory OLTP.Note...
From File Download, clickSaveand browse to a location on your local server. From SQL Server Management Studio, execute the following code: 路径名请自行更改 USE[master] GO CREATEDATABASE[AdventureWorks2012]ON (FILENAME=N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Adve...
To learn about how to work with the SQL Server Database Engine, you can use the samples that are described in the following table. These include sample applications, scripts, language statements, and numerous other samples. You can download these samples from CodePlex. Expand table Name ...
SQL samples repository WideWorldImporters sample database AdventureWorks sample database Azure samples and templates Applies to: SQL Server Azure SQL Database Azure Synapse Analytics Analytics Platform System (PDW) Locations of sample databases and code samples for Microsoft SQL products. ...
Applies to: SQL Server Azure SQL Database Azure Synapse Analytics Analytics Platform System (PDW)Locations of sample databases and code samples for Microsoft SQL products.SQL samples repositoryCode samples for SQL products are in the Microsoft SQL Server samples GitHub repository. Each sample includes...
sample databases are now hosted on CodePlex. Codeplex is the project hosting site for Microsoft SQL Server Samples and Community Projects. The portal page for SQL Server on Codeplex catalogs samples included with Product Releases, samples from the community, and independent SQL Server Community ...
创建新的 SQL Server 数据库 向项目中添加新的数据库 在**“项目”菜单上,单击“添加新项”**。 在可用模板列表中选择**“本地数据库”**。 在**“名称”**框中键入“SampleDatabase”。 单击**“添加”**。 此时将打开**“数据源配置向导”,其中选定新的“SampleDatabase.sdf”**文件作为数据连接。
On CodePlex, you can locate specific projects for the product samples for a technology area of SQL Server (Analysis Services, Database Engine, Data Programmability, and so on) by clicking the link for the technology you want in the technology area table of the Microsoft SQL Server Samples and...
对于本演练,选择完成创建的SampleDatabase.mdf文件程序演练:创建 LocalDB 数据库。 选择数据库所需的身份验证模式和登录信息。有关更多信息,请参见添加/修改连接(Microsoft SQL Server 数据库文件)。 选择确定按钮,然后选择下一步按钮。 说明 本地数据库文件包含在项目中为解决方案的文件。在创建到本地数据库文...
创建新的 SQL Server 数据库向项目中添加新的数据库从**“项目”菜单中选择“添加新项”**。 从可用模板列表中选择**“基于服务的数据库”**。 在**“名称”**区域中键入 SampleDatabase。 单击**“添加”**。 **“数据源配置向导”**将会打开,但因为这是一个新的数据库,没有可用的数据库对象。 单击...