mysql server 使用教程_使用 SQL Server Management Studio (SSMS) 连接和查询 SQL Server 实例 - SQL Server Management...

快速入门：使用 SQL Server Management Studio (SSMS) 连接和查询 SQL Server 实例Quickstart: Connect and query a SQL Server instance using SQL Server Management Studio (SSMS)

12/15/2020

本文内容

适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions)适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions)

开始使用 SQL Server Management Studio (SSMS) 连接到 SQL Server 实例并运行一些 Transact-SQL (T-SQL) 命令。Get started using SQL Server Management Studio (SSMS) to connect to your SQL Server instance and run some Transact-SQL (T-SQL) commands.

本文展示了如何按照以下步骤操作：The article demonstrates how to follow the below steps:

连接到 SQL Server 实例Connect to a SQL Server instance

创建数据库Create a database

在新数据库中创建表Create a table in your new database

在新表中插入行Insert rows into your new table

查询新表并查看结果Query the new table and view the results

使用查询窗口表验证连接属性Use the query window table to verify your connection properties

先决条件Prerequisites

连接到 SQL Server 实例Connect to a SQL Server instance

启动 SQL Server Management Studio。Start SQL Server Management Studio. 首次运行 SSMS 时，系统将打开“连接到服务器”窗口。The first time you run SSMS, the Connect to Server window opens. 如未打开，可以选择“对象资源管理器” > “连接” > “数据库引擎”，将其手动打开。If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine.

此时会显示“连接到服务器”对话框。The Connect to Server dialog box appears. 输入以下信息：Enter the following information:

设置Setting

建议的值Suggested Value(s)

说明Description

服务器类型Server type

数据库引擎Database engine