create_tables.sql

一个支持微软sqlserver 2000 数据库的jdbc驱动程序

create table bcp1
(
	field1 char(10) 
)
go

create table bcp2
(
	field1 char(10),
	field2 int
)
go

create table bcp3
(
	field1 char(30),
	field2 varchar(10),
	field3 char(50),
	field4 float,
	field5 char(50),
	field6 int,
	field7 char(50),
	field8 varchar(50),
	field9 char(50),
	field10 int,
	field11 char(50),
	field12 int
)
go

create table bcp4
(
	field1 char(10),
	field2 varchar(10),
	field3 varchar(20)
)
go

create table bcp5
(
	field1 char(10),
	field2 int null
)
go

create table bcp6
(
	field1 char(1),
	field2 tinyint,
	field3 smallint,
	field4 int,
	field5 float,
	field6 real,
)
go


create table bcp7
(
	field1 char(1),
	field2 datetime,
	field3 smalldatetime
)
go

create table bcp8
(
	field1 char(1),
	field2 numeric(5,2),
	field3 numeric(8,3),
	field4 numeric(12,6)
)
go

create table bcp12
(
	field1 char(10),
	field2 int	null
)
go

create table bcp13
(
	field1 char(10),
	field2 varchar(10) null
)
go

create table bcp14
(
	field1 datetime
)
go

create table bcp15
(
	field1 date
)
go

create table bcp16
(
	field1 time
)
go

create table bcp17
(
	field1 varchar(60),
	field2 varchar(255) null,
	field3 float null,
	field4 char(3) null,
	field5 float null
)
go