1 / 11

MS SQL Server

MS SQL Server. A brief introduction. After MSDE was installed. Access to the SQL Server Service Manager Windows taskbar Windows start menu SQL Server Service Manager dialog box:. Client tools for SQL Server. Book online – it provides online help

amos
Download Presentation

MS SQL Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MS SQL Server A brief introduction

  2. After MSDE was installed • Access to the SQL Server Service Manager • Windows taskbar • Windows start menu • SQL Server Service Manager dialog box:

  3. Client tools for SQL Server • Book online – it provides online help • Enterprise Manager – it administers SQL server databases • Import and Export Data – import, export, and transform data form various sources • Query Analyzer – write an execute SQL statements and scripts These tools are accessed from the start menu

  4. The Enterprise Manager • Graphical tool that let a user manage the databases and their object • It has two sides: • Left side: displays installed instances of SQL Servers in a tree structure • Right side: displays the items in the note currently selected. • Commands can be applied to a selected item: • from the Action menu • from the toolbar • By right-clicking the right side

  5. The Enterprise Manager workspace

  6. The Enterprise Manager let do: • Manage databases • Manage tables • Manage views • Manage database diagrams • View additional information about a table • Execute other MS SQL Server tools • Manage users • Define stored procedures • Define rules

  7. Query Analizer • A user connects to a selected DB server using: • Windows authentication, or • SQL Server authentication

  8. Query Analyzer lets you: • Select or change a database • Write and execute Transact-SQL queries • Browse the database object such as tables • Save queries and results • Load and execute script files • Manage indexes • Connect or disconnect DB servers • Open several windows • Print results • Other functions

  9. Query Browser and a table displayed

  10. Editing and executing a query • Select a database from the combo box in the toolbar or Query menu • Type the query in the query window (open a new query window if required) • Several ways for executing the query: • Press the F5 key • Click the execute query button in the toolbar • Choose the Query Execute command from the menu bar • Results are displayed in the Grid tab of the results pane

  11. Example of a query and its results

More Related