ssms中怎么设置自增
This article explains the process of defining custom color codes for SQL Server connections in SSMS.
本文介绍了在SSMS中为SQL Server连接定义自定义颜色代码的过程。
介绍 (Introduction)
DBAs or developers might work simultaneously with different environments such as production, UAT, staging, development. Sometimes, you might execute a query in a different environment in case you miss to check the environment. We should always be careful as accidentally query execution might put you in trouble. For example, in a development environment, we might drop a few objects without worrying much. If the same object exists in the production database as well and you accidentally run the query in production, you are in big trouble.
DBA或开发人员可能会同时使用不同的环境,例如生产,UAT,登台,开发。 有时,您可能会在其他环境中执行查询,以防您错过检查该环境的机会。 我们应该始终小心,因为意外执行查询可能会给您带来麻烦。 例如,在开发环境中,我们可以放一些对象而不必担心。 如果生产数据库中也存在相同的对象,而您在生产中不小心运行了查询,则将遇到很大麻烦。
指定SSMS连接的自定义颜色 (Specify custom colors for SSMS connection)
Be careful while running any query. You can verify the connected instance using the status bar of SSMS. Each new query window provides the connection details.
运行任何查询时请小心。 您可以使用SSMS的状态栏来验证连接的实例。 每个新的查询窗口均提供连接详细信息。
In the following screenshot, we verify connected SQL instance as well as an authenticated user:
在以下屏幕截图中,我们将验证连接SQL实例以及经过身份验证的用户:
SSMS provides a solution for us to determine the environment as per the environment color coding. For example, we can set a red color for production, yellow for development, etc.
SSMS为我们提供了一种根据环境颜色编码确定环境的解决方案。 例如,我们可以为生产设置红色,为开发设置黄色,等等。
Usually, we launch SSMS, specify the SQL instance, and connect to the respective SQL Server.
通常,我们启动SSMS,指定SQL实例,然后连接到相应SQL Server。
Click on Options, and you get various configuration tabs in SSMS.
单击选项,您将在SSMS中获得各种配置选项卡。