SQLServerCh02
Gửi bởi: Khoa CNTT - HCEM 24 tháng 2 2021 lúc 9:18:30 | Được cập nhật: 8 giờ trước (9:56:12) Kiểu file: PPTX | Lượt xem: 141 | Lượt Download: 1 | File size: 1.905517 Mb
Nội dung tài liệu
Tải xuống
Link tài liệu:
Các tài liệu liên quan
Có thể bạn quan tâm
Thông tin tài liệu
Chapter 2
How to use the
Management Studio
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 1
Objectives
Applied
Use the Management Studio to do any of the following
management tasks:
Start or stop an instance of SQL Server Express
Enable a remote connection to a database
Navigate through the objects of a database
Attach, detach, back up, or restore a database
Set the compatibility level for a database
View the database diagrams for a database
View the column definitions for a table in a database
View or modify the data of a table in a database
Modify the column definitions for a table in a database
Use the Management Studio to run, open, and save SQL queries.
Use the Query Designer to build and run queries.
Use Books Online to look up information about SQL Server.
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 2
Objectives (cont.)
Knowledge
Briefly describe the function of each of these client tools: the
Management Studio, the Query Designer, and Books Online.
Distinguish between Windows authentication and SQL Server
authentication for connecting to a SQL Server database.
Describe what “compatibility level” means when it is applied to
SQL Server.
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 3
The SQL Server Configuration Manager (Services)
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 4
The SQL Server Configuration Manager
(Network Configuration)
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 5
How to connect using Windows authentication
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 6
How to connect using SQL Server authentication
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 7
The Management Studio and the Object Explorer
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 8
The Attach Databases dialog box
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 9
The default directory
for SQL Server 2012 databases
C:\Program Files\Microsoft SQL Server 2012\
MSSQL11.SQLEXPRESS\MSSQL\DATA
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 10
The Back Up Database dialog box
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 11
The default directory
for SQL Server 2012 database backups
C:\Program Files\Microsoft SQL Server 2012\
MSSQL11.SQLEXPRESS\MSSQL\Backup
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 12
The compatibility level option
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 13
The relationships in the AP database
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 14
The columns in the Vendors table
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 15
A row as it’s being modified
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 16
A SELECT statement with a completion list
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 17
The Management Studio with an error message
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 18
Common causes of errors
Forgetting to select the correct database from the Available
Databases combo box
Misspelling the name of a table or column
Misspelling a keyword
Omitting the closing quotation mark for a character string
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 19
The Open File dialog box
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 20
The Query Designer window
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 21
Books Online information
Murach's SQL Server 2012, C2
© 2012, Mike Murach & Associates, Inc.
Slide 22