Run query microsoft sql server management studio

Opens the Query Options dialog box. Use this dialog box to configure the default options for query execution and for query results. You can also select Query Options from the context menu. This option is set by default. Executes the query, returns the query results, and uses the execution plan for the query. The queries appear as a graphical query plan in the Execution plan window.

Provides real-time insights into the query execution process as the controls flow from one query plan operator to another. You can also select the Include Live Query Statistics from the context menu. Includes a Client Statistics window that contains statistics about the query and about the network packets, and the elapsed time of the query. Returns the query results as one or more grids in the Results window.

This option is enabled by default. When the query executes, the Save Results dialog box opens. In Save In , select the folder in which you want to save the file. In Filename , type the name of the file, and then select Save to save the query results as a Report file that has the.

For advanced options, select the down-arrow on the Save button, and then select Save with Encoding. Makes the current line an active source statement by removing any comment operator -- at the beginning of the line. Opens a dialog box that you can use to specify values for parameters in stored procedures and functions. You can access the context menu by right-clicking anywhere in the query editor.

With the context menu, you see the same options as Connect and Execute , but you also get other options listed, such as Insert Snippet and Surround With. Connect - Opens the Connect to Server dialog box. Change Connection - Opens the Connect to Server dialog box. Object Explorer provides a hierarchical user interface to view and manage the objects in each instance of SQL Server.

The Object Explorer Details pane presents a tabular view of instance objects, and the capability to search for specific objects. The capabilities of Object Explorer vary slightly depending on the type of server, but generally include the development features for databases, and management features for all server types.

Executes the selected code or, if no code is selected, executes all the code in the Query Editor. Requests a query execution plan from the query processor without actually executing the query, and displays the plan in the Execution plan window. If the number of rows that are returned is different from the estimate, and the query processor changes the plan to be more efficient, this can occur.

SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. You use the Database Engine Tuning Advisor to select and create an optimal set of indexes, indexed views, or table partitions without having an expert understanding of the database structure or the internals of SQL Server. Using the DTA, you can perform the following tasks.

The Query and View Designer opens when you open the definition of a view, show the results for a query or view, or create or open a query. Results to Text - Returns the query results as text in the Results window. Results to Grid - Returns the query results as one or more grids in the Results window. Results to File - When the query executes, the Save Results dialog box opens. In File name , type the file's name, and then select Save to save the query results as a Report file with the.

The Properties Window describes the state of an item in SQL Server Management Studio, such as a connection or a Showplan operator, and information about database objects such as tables, views, and designers. You use the Properties window to view the properties of the current connection. Many properties are read-only in the Properties window but can be changed elsewhere in the Management Studio. For example, the Database property of a query is read-only in the Properties window but can be changed on the tool bar.

Use this dialog box to configure the default options for query execution and query results. The help search engine then searches for a topic that has an F1 help attribute that matches the string you highlighted. If the help search engine doesn't find a topic with an F1 help keyword that exactly matches the string you highlighted, then this topic is displayed.

In that case, there are two approaches to finding the help you're looking for:. Highlight only the part of the Transact-SQL statement likely to match an F1 help keyword applied to a topic and select F1 again. The search engine requires an exact match between the string you highlighted and an F1 help keyword assigned to a topic.

If the string you highlighted contains elements unique to your environment, such as column or parameter names, the search engine doesn't get a match. Examples of the strings to highlight include:. The name of a system stored procedure table, or views, such as sys. You can also view the query duration and the number of rows that are returned by the previously executed query.

The best way to get acquainted with SSMS is through hands-on practice. These articles help you with various features available within SSMS.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback?

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.

Submit and view feedback for This product This page. View all page feedback. In this article. For Server type , select Database Engine usually the default option. For Server name , enter the name of your SQL Server you can also use localhost as the server name if you're connecting locally. Windows Authentication is set as default. For more information about authentication types, see Connect to the server database engine. The user ID from the server account used to log in to the server.

The password from the server account used to log in the server.