【SQL开源代码栏目提醒】：网学会员鉴于大家对SQL开源代码十分关注，论文会员在此为大家搜集整理了“中文SQL_Server_2005数据库管理与开发源代码 - 能源电力”一文，供大家参考学习

源代码第2章Create database testOn primaryNAME test_datFILENAME C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatatest.mdfSIZE 10MBMAXSIZE 50MBFILEGROWTH 15FILEGROUP test_dataNAMEtest_data_datFILENAMEC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatatest_data.ndfSIZE100MBMAXSIZE500MBFILEGROWTH10MBLOG ONNAME Sales_logFILENAME C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatatestlog.ldfSIZE 5MBMAXSIZE 25MBFILEGROWTH 2MBGO例1 ALTER DATABASE testMODIFY FILENAMEtest_datSIZE25MBGO例2 ALTER DATABASE testADD FILENAMEtest_data_dat2FILENAMEC:Program FilesMicrosoft SQLServerMSSQL.1MSSQLDatatest_data2.ndfSIZE50MBMAXSIZE100MBFILEGROWTH5MBGO例3 DROP DATABASE test GO第3章例1 USE basetestExec sp_addtype sname varchar10Exec sp_addtype birthday smalldatetimenull例 2 Exec sp_droptype snameCREATE TABLE basetest.dbo.coursecno char2 UNIQUEcname char20 NOT NULL UNIQUEcpni char2 ccredit char5USE basetestDELETE FROM course WHERE cno2第4章例 1 USE basetestSELECT FROM student例 2 USE basetestSELECT snamessex FROM student例 3 USE basetestSELECT sname2006-sage FROM student例 4 USE basetestSELECT sname AS 学生姓名2006-sage AS 出生年月FROM student例 5 USE basetestSELECT TOP 5 FROM student例 6 USE basetestSELECT DISTINCT sno from sc例 7 USE basetestSELECT student.snosnamesdeptcnogradeFROM student JOIN scON student.snosc.sno例 8 USE basetestSELECT student.snosnamesdeptcnogradeFROM student LEFT JOIN SCON student.snosc.sno例 9 USE basetestSELECT snamessexsageFROM studentWHERE sage20USE basetestSELECT snamessexsageFROM studentWHERE NOT sage20第5章例 1 USE basetestGOCREATE VIEW MA 系的学生信息 AS SELECT FROM student WHERE sdeptMA例 2 USE basetestGOCREATE VIEW ＩＳ系女生选课信息学号姓名性别选修课号成绩AS SELECT student.snosnamessexcnograde FROM studentsc WHERE student.snosc.sno AND ssex女例 3 USE basetestGOCREATE VIEW 男生信息视图ASSELECT FROM studentWHERE sdept男WITH CHECK OPTION例 4 USE basetestGOCREATE VIEW CS 系学生信息AS SELECT FROM student WHERE sdeptCSUSE basetestGOALTER VIEW CS 系学生信息学号姓名性别年龄WITH ENCRYPTIONASSELECT snosnamessexsageFROM studentWHERE sdeptCS例 5 USE basetestDROP VIEW 学生选课信息例 6 USE basetestSELECT FROM CS 系学生信息WHERE 性别女例 7 USE basetestUPDATE CS 系学生信息SET 年龄21WHERE 学号05008第6章例 1 USE basetestGOCREATE TABLE student_testsno intsname char5 UNIQUEGOEXEC sp_helpindex student_test例 2 USE basetestGOCREATE TABLE student_test1sno int primary keysname char5GOEXEC sp_helpindex student_test1例 3 USE basetestGOCREATE TABLE student_test3sno int sname char5ssex char2sdept char5CREATE UNIQUE INDEX index_studentON student_test3snosnameWITH PAD_INDEXFILLFACTOR60CREATE INDEX index_sdeptON student_test3sdeptEXEC sp_helpindex student_test3第7章例 1 USE basetestGOSELECT COL_LENGTHstudentsname AS 姓名长度FROM studentGO例 2 Select 当前日期GETDATE月MONTHGETDATE日DAYGETDATE年YEARGETDATE例 3 Print STUFFabXYFfghijklmn33cde例 4 USE basetestGOSELECT snoROUNDAVGgrade4AS 平均成绩FROM scGROUP BY sno例 5 USE basetestGOCREATE FUNCTION info_studentsno nchar8RETURNS FLOATASBEGINDECLARE Grade FLOATSET GradeSELECT AVGgrade FROM sc WHERE snosno GROUP BY sno RETURN GradeEND例 6 USE basetestGOCREATE FUNCTION info_sdeptsdept nchar10RETURNS TABLEASRETURN SELECT snosnamessex FROM student WHERE sdeptsdeptUSE basetestGOSELECT FROM dbo.info_sdeptMA例 7 USE basetestGOCREATE FUNCTION higher_gradehighergrade FLOATRETURNS higher_grade TABLE sno char10sname char20grade FLOATASBEGIN INSERT higher_grade SELECT student.snosnamegrade FROM studentsc WHERE student.snosc.sno AND gradehighergrade RETURNENDGO例 8 USE basetestGODECLARE GRADE FLOATMESSAGE varchar200SET GRADE98IF EXISTSSELECT FROM sc WHERE gradeGRADE BEGIN SELECT DISTINCT student.snosnamegrade FROM s