双色球数据库简单构建

1.CREATE DATABASE

use master
go
create database ssq
on
(name=ssq_dat,filename='e:\ssq.mdf',size=100mb,maxsize=500mb,filegrowth=10mb)
log on
(name=ssq_log,filename='e:\ssq.ldf',size=50mb,maxsize=300mb,filegrowth=5mb);
go

2.CREATE TABLE

 create table ssq_data2003(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)
 create table ssq_data2004(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2005(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2006(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2007(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2008(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2009(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2010(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2011(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2012(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 create table ssq_data2013(date_ssq int NOT NULL,number_ssq char(50) NOT NULL)

 GO

3.INSERT DATA

insert into ssq_data2003 values('2003001','101112132628_11')
go

或者

insert into ssq_data2003(date_ssq,number_ssq) values('2003001','101112132628_11')
go