ms sql server n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
MS SQL Server PowerPoint Presentation
Download Presentation
MS SQL Server

Loading in 2 Seconds...

play fullscreen
1 / 11

MS SQL Server - PowerPoint PPT Presentation


  • 98 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'MS SQL Server' - amos


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ms sql server

MS SQL Server

A brief introduction

after msde was installed
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
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

the enterprise manager
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
the enterprise manager let do
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
query analizer
Query Analizer
  • A user connects to a selected DB server using:
    • Windows authentication, or
    • SQL Server authentication
query analyzer lets you
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
editing and executing a query
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