Versions Compared

Old Version 2

changes.mady.by.user Evgeniya Kononova

Saved on

compared with

New Version Current

changes.mady.by.user Darya Andryieuskaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Download (from Microsoft website) and install SQL Server Management Studio 2014 (see Microsoft documentation).
  2. Start SQL Server Management Studio utility. Click Start -> All Programs -> Microsoft SQL Server 2014 -> SQL Server Management Studio.
  3. Specify parameters of connection to MS SQL server in the Connect to Server box window.
    Image Modified
    1. Select the Database Engine type in the Server type list (1).
    2. Select the name of MS SQL server to wich which it is necessary to connect in the Server name list (2).

    3. Select authentication type used for connection to MS SQL server in the Authentication list (3).

      Info
      titleNote.
      The type of authentication that was selected while creating MS SQL server is specified.


      Info
      titleNote.
      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).


  4. Click Connect to connect to MS SQL server. If the connection is successful, then the Object Explorer box window is displayed.
    Image Modified
  5. Open the embedded list of the Databases catalogue in the Object Explorer box and go to the required database.
    Image Modified
  6. Select the table for viewing in the Tables catalogue.
  7. Select Select Top 1000 Rows item in the context menu of the table.
    Image Modified

As a result, the box with SQL Query on top of it and the table data selected by the query will be displayed.

Info
titleNote.
Using Select Top 1000 Rows command one can query the latest rows stored into the table. Not more than 1000 rows respond to a query.


Info
titleNote.
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 Modified

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.

Image Modified

Info
titleNote.
 To execute the query, click  on the toolbar.


Info
titleExample.

 Select all video cameras created on the basis of Video Capture Device 2.

Image Modified


Viewing Axxon PSIM™ software PSIM database is now completed.

Info
titleNote.
To view databases of other formats, the SQL Server Management Studio utility can also be used. For this install the package of ODBC drivers and OLE DB provider that can be found at http://www.microsoft.com. To connect to database Server, use sp_addlinkedserver stored procedure. Its description and examples of use are at http://msdn.microsoft.com.

...