...
- 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.
Image Removed
Image Added
- Select the Database Engine type in the Server type list (1).
- Select the name of MS SQL server to wich 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 |
---|
|
The type of authentication that was selected while creating MS SQL server is specified. |
Info |
---|
|
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 is displayed.
Image Removed
Image Added - Open the embedded list of the Databases catalogue in the Object Explorer box and go to the required database.
Image Removed
Image Added - Select the table for viewing in the Tables catalogue.
- Select Select Top 1000 Rows item in the context menu of the table.
Image Removed
Image Added
As a result the box with SQL Query on top of it and the table data selected by the query will be displayed.
...
Info |
---|
|
One can change the quantity of rows and set of fields requested in the table by editing SQL Query. To start modified SQL Query click Image Removed Image Added on the toolbar. |
Image Removed
Image Added
If one need to create his own query, then select Script Table as -> SELECT To -> New Query Editor Window in the context menu and type-in SQL Query in the box.
Image Removed
Image Added
Info |
---|
|
To execute the query click Image Removed Image Added on the toolbar. |
...
Info |
---|
|
Select all video cameras created on the basis of Video Capture Device 2. Image Removed Image Added
|
Viewing INTELLECT™ Axxon PSIM™ software database is now completed.
...