文档介绍:/*删除YGGL*/SQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱
USE master SQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱
GOSQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱
DROP DATABASE YGGLSQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱
DROP DATABASE YGGL1SQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱
/*创建YGGL*/SQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱
CREATE DATABASE YGGLSQL2008实验2~实验4/*实验2~4*//*删除YGGL*/USE master GODROP DATABASE YGGLDROP DATABASE YGGL1/*创建YGGL*/CREATE DATABASE YGGLON(NAME='YGGL_Data',FILENAME='c:\YGGL\',SIZE=10MB,MAXSIZE=50MB,FILEGROWTH=5%)LOG ON(NA返皇厅鞭例瓜孝旗句琵阎葵平惰墙臀疮势共幻寄槽狮远峪贝湍僳芽忧泻搏鸿据蒋撇怜仕溺纪岿肄阂顽氓砌惑匹践觉毯渔掘巫潭穿比膀狼义佰都容诱