How do I find the server name for "SQL Server Management Studio 17.1", downloaded at https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
如何找到“SQL Server Management Studio 17.1”的服务器名称,可从https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms下载
Thank you.
谢谢。
1 个解决方案
#1
0
Please refer to this link to know what SQL Server Management Studio is:
请参阅此链接以了解SQL Server Management Studio是什么:
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and SQL Data Warehouse. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators [...].
SQL Server Management Studio(SSMS)是一个用于管理任何SQL基础结构的集成环境。使用SSMS访问,配置,管理,管理和开发SQL Server,Azure SQL数据库和SQL数据仓库的所有组件。 SSMS提供了一个单一的综合实用程序,它将大量图形工具与许多丰富的脚本编辑器相结合,为开发人员和数据库管理员提供对SQL Server的访问[...]。
You are confusing the management studio with an effective database engine. You use the management studio to connect to one or more SQL Server databases. At that point, you can then access, configure, manage, administer, and develop all components of a SQL Server database.
您将管理工作室与有效的数据库引擎混淆。您使用管理工作室连接到一个或多个SQL Server数据库。此时,您可以访问,配置,管理,管理和开发SQL Server数据库的所有组件。
Suppose you have SSMS and connect to a SQL Server instance. You can then query a database on the SQL Server instance with ad-hoc queries. One such query could be
假设您有SSMS并连接到SQL Server实例。然后,您可以使用即席查询在SQL Server实例上查询数据库。一个这样的查询可能是
SELECT @@SERVERNAME
which would return the server name of the SQL Server instance.
这将返回SQL Server实例的服务器名称。
#1
0
Please refer to this link to know what SQL Server Management Studio is:
请参阅此链接以了解SQL Server Management Studio是什么:
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and SQL Data Warehouse. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators [...].
SQL Server Management Studio(SSMS)是一个用于管理任何SQL基础结构的集成环境。使用SSMS访问,配置,管理,管理和开发SQL Server,Azure SQL数据库和SQL数据仓库的所有组件。 SSMS提供了一个单一的综合实用程序,它将大量图形工具与许多丰富的脚本编辑器相结合,为开发人员和数据库管理员提供对SQL Server的访问[...]。
You are confusing the management studio with an effective database engine. You use the management studio to connect to one or more SQL Server databases. At that point, you can then access, configure, manage, administer, and develop all components of a SQL Server database.
您将管理工作室与有效的数据库引擎混淆。您使用管理工作室连接到一个或多个SQL Server数据库。此时,您可以访问,配置,管理,管理和开发SQL Server数据库的所有组件。
Suppose you have SSMS and connect to a SQL Server instance. You can then query a database on the SQL Server instance with ad-hoc queries. One such query could be
假设您有SSMS并连接到SQL Server实例。然后,您可以使用即席查询在SQL Server实例上查询数据库。一个这样的查询可能是
SELECT @@SERVERNAME
which would return the server name of the SQL Server instance.
这将返回SQL Server实例的服务器名称。