文件名称：数据库的基本操作以及应用
文件大小：2KB
文件格式：TXT
更新时间：2013-01-03 03:04:21
数据库 语句 表的操作
create database sjk2 on ( name = zxx, filename = 'D:\sjk2\zxx.mdf', size = 6, maxsize = 20, filegrowth = 10% ) log on ( name = zxx_log, filename = 'D:\sjk2\zxx_log.ldf', size = 2, maxsize = 10, filegrowth = 2 ) go use sjk2 create table orders ( dddh varchar(10), khdh varchar(6), cpdh varchar(8), ddje money, ddrq datetime ) insert into orders values('2009030563','109806','CK2000-A',3500.0000,'2009-03-05') insert into orders values('2009030629','109806','CK2010-A',4600.0000,'2009-03-06') insert into orders values('2009030630','375880','CKA109',4500.0000,'2009-03-06') insert into orders values('2009030811','A19005','CKA109',5500.0000,'2009-05-05') insert into orders values('2009030822','289022','CKC100A',4800.0000,'2009-06-05') select * from orders use sjk2 create table orders1 ( dddh varchar(10), khdh varchar(6), cpdh varchar(8), ddje money, ddrq datetime ) insert into orders1 (khdh,cpdh,ddje,ddrq) select khdh,cpdh,ddje,ddrq from orders select *from orders1 select khdh,cpdh,ddje,ddrq into orders2 from orders select * from orders2