Giáo trình SQL Bài 2

Chia sẻ: Nguyen Kien | Ngày: | Loại File: PDF | Số trang:0

Thêm vào BST

Báo xấu

163
lượt xem 53
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Tham khảo tài liệu 'giáo trình sql bài 2', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Giáo trình SQL Bài 2

Lab 01 a SQL Server 2008 1
Outlines n SQL Server 2008 n Install guide n Using T-SQL Faculty of Science and Technology Database Fundamentals 2
SQL Server 2005 n Microsoft SQL Server 2005 extends the performance, reliability, availability, programmability n ease-of-use of SQL Server 2000. n includes several new features that make it an excellent database platform for : n large-scale online transactional processing (OLTP) n data warehousing n e-commerce applications. Faculty of Science and Technology Database Fundamentals 3
Faculty of Science and Technology Database Fundamentals 4
Prerequires Software n .NET Framework 3.5 n MSXML Faculty of Science and Technology Database Fundamentals 5
Installation n Reading: how-to-install-sql-server-2008-a-step-by-step- guide.pdf Faculty of Science and Technology Database Fundamentals 6
Veryfy the installation n Click Start à Run à Cmd. n Type the following command and press ENTER: NET START MSSQLSERVER ↵ Faculty of Science and Technology Database Fundamentals 7
n Enter the following command to connect to MSSQLSERVER using the SQLCMD utility. Enter the following Transact-SQL commands to retrieve the server name: SELECT @@SERVERNAME GO Faculty of Science and Technology Database Fundamentals 8
n Confirm that the server name is returned, and then enter the following command to exit the SQLCMD utility: Exit Faculty of Science and Technology Database Fundamentals 9
SQL Server Management Studio n Start à Programs à SQL Server 2008 à SQL Server Management Studio 1. Enter Password (If exists ) 2. click Connect Faculty of Science and Technology Database Fundamentals 10
SQL Server Management Studio (2) Faculty of Science and Technology Database Fundamentals 11
Using T-SQL n File à New à Query with Current Connection n Or click SQL Edit toolbar Faculty of Science and Technology Database Fundamentals 12
SQL Editor Toolbar (1) n Connect Opens the Connect to Server dialog box. Use this dialog box to establish a connection to a server. n Disconnect Disconnects the current Query Editor from the server. n Change Connection Opens the Connect to Server dialog box. Use this dialog box to establish a connection to a different server. n New Query with Current Connection Opens a new Query Editor window and uses the connection information from the current Query Editor window. n Available Databases Change the connection to a different database on the same server. Faculty of Science and Technology Database Fundamentals 13
SQL Editor Toolbar (2) n Execute Executes the selected code or, if no code is selected, executes all the code in the Query Editor. n Debug Enables the Transact-SQL debugger. This debugger supports debugging actions such as setting breakpoints, watching variables, and stepping through code. n Cancel Executing Query Sends a cancellation request to the server. Some queries cannot be canceled immediately, but must wait for a suitable cancellation condition. When transactions are canceled, delays might occur while transactions are rolled back. n Parse Check the syntax of the selected code. If no code is selected, checks the syntax of the all code in the Query Editor window. Faculty of Science and Technology Database Fundamentals 14
Faculty of Science and Technology Database Fundamentals 15