Go to documentation repository
Page History
...
- Download (from Microsoft website) and install SQL Server Management Studio 2014 (see Microsoft documentation).
- Start SQL Server Management Studio utility. Click Start -> All Programs -> Microsoft SQL Server 2014 -> SQL Server Management Studio.
- Specify parameters of connection to MS SQL server in the Connect to Server box window.
- Select the Database Engine type in the Server type list (1).
- Select the name of MS SQL server to wich which it is necessary to connect in the Server name list (2).
Select authentication type used for connection to MS SQL server in the Authentication list (3).
Info title Note. The type of authentication that was selected while creating MS SQL server is specified. Info title Note. If SQL Server Authentication type is used, then select the user in the Login list and type-in the required password in the Password field (3).
- Click Connect to connect to MS SQL server. If the connection is successful, then the Object Explorer box window is displayed.
- Open the embedded list of the Databases catalogue in the Object Explorer box and go to the required database.
- Select the table for viewing in the Tables catalogue.
- Select Select Top 1000 Rows item in the context menu of the table.
...
If one need to create his own query, then select Script Table as -> SELECT To -> New Query Editor Window in the context menu menu and type-in SQL Query in the box.
...
Overview
Content Tools