Available Databases using the editor toolbarĬhange the connection to a different database on the same server. You can also change connections using the context menu. Use this dialog box to establish a connection to a different server. Change Connection using the editor toolbar You can also connect to your database using the context menu. Use this dialog box to establish a connection to a server. If you add the SQL Editor toolbar when no Query Editor windows are open, all the buttons are unavailable. You can also add the SQL Editor toolbar by selecting the View menu, selecting Toolbars, and then selecting SQL Editor.

When the Query Editor is open, the SQL Editor toolbar appears with the following buttons. You can use the Query Editor to create and run scripts containing Transact-SQL statements. The query editors include the Database Engine Query Editor for use in building scripts containing T-SQL and XQuery statements, the MDX editor for the MDX language, the DMX editor for the DMX language, and the XML/A editor for the XML for Analysis language. The query editors also implement varying levels of support for editor features such as IntelliSense and debugging. The other editors, or query editors, extend this functionality base by including a language service that defines the syntax of one of the languages supported in SQL Server. The text editor implements the base level of functionality and can be used as a basic editor for text files. The editors in SSMS share a typical architecture.

If you want to learn about tasks that you can do with the editor, please visit the Editor tasks section. If you want to learn how to use Transact-SQL (T-SQL) F1 Help, please view the Transact-SQL F1 Help section.

Sql code writer