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
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')
- 粉丝: 0
- 资源: 2
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助