tailieunhanh - Microsoft SQL Server 2005 Express Edition for Dummies phần 4

• Vai trò Server: Sử dụng trang này, bạn có thể liên kết này người dùng cơ sở dữ liệu mới với một tập hợp các hồ sơ bảo mật được xác định trước. • Người dùng Bản đồ: Đây là nơi bạn kết hợp một cơ sở dữ liệu người dùng từ Windows Với một hệ điều hành. • Bảo vệ: Đây là nơi bạn có thể bảo mật cao cụ thể thiết lập các tiêu chí. • Tình trạng: | 110 Part III Adding and Accessing a SQL Server 2005 Express Database Figure 8-1 The SQL Server Management Studio Express Object Explorer. To get the latest-and-greatest view of everything about your SQL Server 2005 Express instance right-click anywhere on the Object Explorer tree and choose Refresh. The Query window The Query window is where you and SQL Server 2005 Express get to know each other up close and personal. The workspace contains input windows described as the Query Editor for queries and other data interaction. You can also elect to have your output show up at the bottom of the screen in the area described as the Output window . You can create as many Query Editor windows as you need simply by clicking the New Query icon on the Standard toolbar. When you re comfortable working in the workspace you can decide how and where you want your results to appear. You have three options click one of these icons at the top of the window Chapter 8 Creating Databases Tables and Relationships 111 Text This formats your output into simple text and places it in the Output window. Grid This option provides more attractive results placing them into a grid at the bottom of the Output window. File This is the to-go option for your queries. SQL Server 2005 Express takes the results and nicely places them in a text file. Creating Key Database Objects In this section I show you how to use a combination of graphical and text tools to create and maintain major database objects. Databases Creating altering and deleting databases are significant events in the life of your SQL Server 2005 Express environment. However none of these tasks requires much heavy lifting as you ll now see. Creating a database To create a database just follow these steps 1. Launch SQL Server Management Studio Express. 2. Connect to the appropriate SQL Server 2005 Express instance. 3. Expand the connection s entry in the Object Explorer. 4. Highlight the Databases folder. 5. Right-click this folder and .