MS SQL Server 使用.docVIP

实验一 MS SQL Server 的使用 Microsoft SQL Server 2000的安装 Service Manager Enterprise Manager 注册SQL Server SQL Server Group → SQL Server 创建数据库 Database → newdatabase → dbname(dbname_Data.MDF, dbname_Log.LDF) Location: c:\Program files\Microsoft SQL Server\MSSQL\DATA\… 创建基本表 Table → NEW → 列名 → 类型 → 长度、NULL、Key 按照上述步骤，创建以下基本表： Product(maker,model,type) PC(model,speed,ram,hd,cd,price) Laptop(model,speed,ram,hd,screen,price) Printer(model, color,type,price) 输入数据 Tables → T1 → open table 给以下关系输入数据： Product(maker,model,type) PC(model,speed,ram,hd,cd,price) Laptop(model,speed,ram,hd,screen,price) Printer(model, color,type,price) 数据查询 使用SQL完成以下查询： P252 6.1.3 Find the model number, speed, and hard-disk size for all PC’s whose price is under $1600. Do the same as (a), but rename the speed column megahertz and the hd column gigabytes. Find the manufacturers of printers. Find the model number, memory size, and screen size for laptops costing more than $2000. Find all the tuples in the Printer relation for color printers. Find the model number, speed, and hard-disk size for those PC’s that have either a 6x or 8x CD and a price less than $2000. P262 6.2.2 Give the manufacturer and speed of laptops with a hard disk of at least one gigabyte. Find the model number and price of all products (of any type) made by manufacturer B. Find those manufacturers that sell Laptops, but not PC’s. Find those hard-disk sizes that occur in two or more PC’s. Find those pairs of PC models that have both the same speed and RAM. Find those manufacturers of at least two different computers (PC’s or laptops) with speeds of at least 133. 另一个查询工具： Database → Tools → SQL Server Query Analyzer → DB 数据库备份 Backup Database → c:\Program files\Microsoft SQL Server\MSSQL\BACKUP 数据库恢复 Restore Database → name 分离数据库 附加数据库→ c:\Program files\Microsoft SQL Server\MSSQL\data\dbname_Data.MDF 数据的导入/导出 课外上机： 为你的数据库应用课题建立数据库，建立各关系，并输入数据 设计关于该数据库的各类查询问题，并完成查询 分离数据库