If your SQL instance is a named instance, it may have either been configured to use dynamic ports or a static port. In either case, the underlying network libraries query SQL Browser service running on your SQL Server machine via UDP port 1434 to enumerate the port number for the named instance. Dec 05, 2016 SQL Server Instance Name: In SQL Server Management Studio-RegisterServers-double click your server to open the Object Explorer - right click to select the properties window -General Tab - to see the ServerName (instance name) or Open a new query in SQL Server Management window and execute the following.
-->
This tutorial teaches you how to use SQL Server Management Studio (SSMS) to connect to your SQL Server instance and run some basic Transact-SQL (T-SQL) commands. The article demonstrates how to follow the below steps:
Microsoft Sql Server CertificationPrerequisites
To complete this tutorial, you need SQL Server Management Studio and access to a SQL Server instance.
If you don't have access to a SQL Server instance, select your platform from the following links. If you choose SQL Authentication, use your SQL Server login credentials.
Connect to a SQL Server instance
Examples of successful connections
To verify that your SQL Server connection succeeded, expand and explore the objects within Object Explorer. These objects are different depending on the type of server you choose to connect.
Create a database
Create a database named TutorialDB by following the below steps:
Create a table in the new database
In this section, you create a table in the newly created TutorialDB database. Because the query editor is still in the context of the master database, switch the connection context to the TutorialDB database by doing the following steps:
After the query is complete, the new Customers table is displayed in the list of tables in Object Explorer. If the table isn't displayed, right-click the TutorialDB > Tables node in Object Explorer, and then select Refresh.
Insert rows into the new table
Insert some rows into the Customers table that you created previously. To do so, paste the following T-SQL code snippet into the query window, and then select Execute:
Query the table and view the results
The results of a query are visible below the query text window. To query the Customers table and view the rows that were previously inserted, follow these steps:
Verify your connection properties by using the query window table
You can find information about the connection properties under the results of your query. After you run the previously mentioned query in the preceding step, review the connection properties at the bottom of the query window.
Change the server based on the query window
You can change the server that your current query window is connected to by following the steps below:
Next steps
The best way to get acquainted with SSMS is through hands-on practice. These articles help you with various features available within SSMS. These articles teach you how to manage the components of SSMS and how to find the features that you use regularly.
Enterprise
Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.
Enterprise
Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.
Standard
Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.
Standard
Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.
Express
Build small, media='(min-width:540px)'>
Ms Sql Server Instance ConfigurationExpress
Build small, media='(min-width:540px)'>
Developer
Build, test, and demonstrate applications in a non-production environment with this full-featured edition of SQL Server 2017.
DeveloperWhat Is Microsoft Sql Server
Build, test, and demonstrate applications in a non-production environment with this full-featured edition of SQL Server 2017.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |