The Basics of SSMS and Its Features
Explore the fundamental features of SQL Server Management Studio including managing database connections, executing SQL queries, and utilizing IntelliSense for code suggestions. Understand how to navigate the Object Explorer and control result presentation. Gain practical skills to efficiently interact with SQL Server databases through SSMS.
Managing connections
There are several ways to manage connections to servers within SSMS. The connection near the top arrow allows managing connections to database servers within the current query. The connection near the bottom arrow will enable us to manage connections to many database servers in SSMS.
Choosing the database
Within SSMS, we can choose the databases we prefer to use, depending on which database server we connect to. All we have to do is click the “Databases” and click the desired database from the drop-down list.
New query window
To run queries against the database, we must open a query session. There are a few ways of doing this. One is to click the “New Query” button as shown below to open a query to the current database connection. We can also see that the shortcut is “Ctrl + N.”
The second way to do this is by using the “Object Explorer” window and finding the database we want to use. ...