中文SQL_Server_2005数据库管理与开发源代码.docVIP

源代码 第2章 Create database test On primary NAME test_dat, FILENAME C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf, SIZE 10MB, MAXSIZE 50MB, FILEGROWTH 15% , FILEGROUP test_data NAME test_data_dat, FILENAME C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_data.ndf, SIZE 100MB, MAXSIZE 500MB, FILEGROWTH 10MB LOG ON NAME Sales_log, FILENAME C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\testlog.ldf, SIZE 5MB, MAXSIZE 25MB, FILEGROWTH 2MB GO 例1 ALTER DATABASE test MODIFY FILE NAME test_dat, SIZE 25MB GO 例2 ALTER DATABASE test ADD FILE NAME test_data_dat2, FILENAME C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_data2.ndf, SIZE 50MB, MAXSIZE 100MB, FILEGROWTH 5MB GO 例3 DROP DATABASE test GO 第3章 例1 USE basetest Exec sp_addtype sname, varchar 10 Exec sp_addtype birthday, smalldatetime,null 例2 Exec sp_droptype sname CREATE TABLE basetest.dbo.course cno char 2 UNIQUE, cname char 20 NOT NULL UNIQUE, cpni char 2 , ccredit char 5 USE basetest DELETE FROM course WHERE cno 2 第4章 例1 USE basetest SELECT * FROM student 例2 USE basetest SELECT sname,ssex FROM student 例3 USE basetest SELECT sname,2006-sage FROM student 例4 USE basetest SELECT sname AS 学生姓名,2006-sage AS 出生年月FROM student 例5 USE basetest SELECT TOP 5 * FROM student 例6 USE basetest SELECT DISTINCT sno from sc 例7 USE basetest SELECT student.sno,sname,sdept,cno,grade FROM student JOIN sc ON student.sno sc.sno 例8 USE basetest SELECT student.sno,sname,sdept,cno,grade FROM student LEFT JOIN SC ON student.sno sc.sno 例9 USE basetest SELECT sname,ssex,sage FROM student WHERE sage 20; USE basetest SELECT sname,ssex,sage FROM student WHERE NOT sage 20; 例10 USE basetest SELECT sname,ssex,sage FROM student WHERE sage BETWEEN 21 AND 23 例11 USE basetest SELECT sname,sno,sage,sdept FROM student WHERE sname LIKE 黄%; 例12 USE basetest SELECT sname,ssex,sage FROM student WHERE sdept IN MA ; 例13 USE basetest SELECT cname,ccredit FROM course WHERE cpn