Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P131: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 632 Chapter 14 Implementing Objects EXERCISE 14.1 Creating Tables Constraints and Indexes In this exercise you will use Transact-SQL statements to create a table named Planets. You will create constraints and indexes on the table to enable fast search and data validation. You will also create a full-text catalog on the TeamMembers table. Before you begin you must have the following software installed on your computer SQL Server 2008 a free trial is available for download AdventureWorks sample database 1. Open SQL Server Management Studio. To do this click Start All Programs Microsoft SQL Server 2008 SQL Server Management Studio. 2. Create a new query against the AdventureWorks database 3. Create the Planets table and insert three rows of data into it using the following statement. IF Exists SELECT FROM sys.tables WHERE name Planets DROP TABLE Planets GO CREATE TABLE Planets PlanetID int IDENTITY PRIMARY KEY NONCLUSTERED PlanetName varchar 50 NOT NULL PlanetType varchar 50 NULL Radius int CHECK Radius 1000 PlanetDescription varchar max GO INSERT Planets PlanetName PlanetType Radius VALUES Earth Terrestrial Planet 6371 Jupiter Gas Giant 71492 Venus Terrestrial Planet 6051 GO 4. View the data in the Planets table using the following statement. SELECT FROM Planets Implementing Objects Chapter 14 633 5. Create a unique clustered index on the PlanetName column with 80 FILLFACTOR using the following statement. CREATE UNIQUE CLUSTERED INDEX Ix_Planet_Name ON Planets PlanetName WITH PAD_INDEX ON FILLFACTOR 8 0 GO 6. Update the table to include planet descriptions. Create a full-text index on the PlanetDescription column. UPDATE Planets SET PlanetDescription Earth is the third planet from the Sun. Earth is the largest of the terrestrial planets in the Solar System in diameter mass and density. WHERE PlanetName Earth UPDATE Planets SET PlanetDescription Jupiter is the fifth planet from the Sun and the largest planet within the Solar System. WHERE PlanetName Jupiter UPDATE .
