建表:
CREATE TABLE "
test\"."testvar" (
"bigint" bigint NULL DEFAULT autoincrement,
"binary" binary(1) NULL DEFAULT current database,
"bit" bit NULL DEFAULT 12345,
"char" char(5) NULL DEFAULT 'char',
"CLOB" "CLOB" NULL DEFAULT current database,
"date" date NULL DEFAULT current date,
"datetime" "datetime" NULL DEFAULT current timestamp,
"decimal" decimal(30,6) NULL DEFAULT autoincrement,
"double" double NULL DEFAULT autoincrement,
"float" float NULL DEFAULT autoincrement,
"image" "image" NULL DEFAULT current database,
"integer" integer NULL DEFAULT autoincrement,
"long binary" long binary NULL DEFAULT current database,
"long varchar" long varchar NULL DEFAULT current database,
"money" "money" NULL DEFAULT autoincrement,
"numeric" numeric(30,6) NULL DEFAULT autoincrement,
"oldbit" "oldbit" NULL DEFAULT autoincrement,
"real" float NULL DEFAULT autoincrement,
"smalldatetime" "smalldatetime" NULL DEFAULT current timestamp,
"smallint" smallint NULL DEFAULT autoincrement,
"smallmoney" "smallmoney" NULL DEFAULT autoincrement,
"sysname" "sysname" NULL DEFAULT current database,
"text" "text" NULL DEFAULT 'text',
"time" time NULL DEFAULT current time,
"timestamp" timestamp NULL DEFAULT current timestamp,
"tinyint" tinyint NULL DEFAULT autoincrement,
"uniqueidentifier" uniqueidentifier NULL DEFAULT '1234',
"uniqueidentifierstr" "uniqueidentifierstr" NULL DEFAULT current database,
"unsigned bigint" unsigned bigint NULL DEFAULT autoincrement,
"unsigned int" unsigned int NULL DEFAULT autoincrement,
"unsigned smallint" unsigned smallint NULL DEFAULT autoincrement,
"varbinary" varbinary(1) NULL DEFAULT current database,
"varchar" varchar(1) NULL DEFAULT 'varchar',
"xml" "xml" NULL DEFAULT 'xml'
) IN "SYSTEM";
插入一条数据:
insert into "test"."testvar" (
"bigint","binary","bit","char","CLOB","date",
"datetime","decimal","double","float",image,
"integer","long binary","long varchar","money",
"numeric","oldbit","real","smalldatetime","smallint",
"smallmoney","sysname","text","time","timestamp","tinyint",
"uniqueidentifier","uniqueidentifierstr","unsigned bigint",
"unsigned int","unsigned smallint","varbinary","varchar","xml")
values(
1,0x74,1,'char','<NCLOB>','2007-01-14',
'2007-01-01 00:00:00.000',1.000000,1.0,1.0,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,
1,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,'1',1.0000,
1.000000,1,1.0,'2007-07-11 10:19:05.031',1,
1.0000,'1','test','10:19:05.031','2007-06-23 10:19:05.031',1,
0x00309f9284d44515a7969478bc2eb1a3,'00309F92-84D4-4515-A796-9478BC2EB1A3',1,
1,1,0x30,'1','xml') ;
插入10000条数据
WHILE (select count(*) from "test"."testvar") <= 10000 LOOP
insert into "test"."testvar" (
"bigint","binary","bit","char","CLOB","date",
"datetime","decimal","double","float",image,
"integer","long binary","long varchar","money",
"numeric","oldbit","real","smalldatetime","smallint",
"smallmoney","sysname","text","time","timestamp","tinyint",
"uniqueidentifier","uniqueidentifierstr","unsigned bigint",
"unsigned int","unsigned smallint","varbinary","varchar","xml")
values(
1,0x74,1,'char','<NCLOB>','2007-01-14',
'2007-01-01 00:00:00.000',1.000000,1.0,1.0,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,
1,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,'1',1.0000,
1.000000,1,1.0,'2007-07-11 10:19:05.031',1,
1.0000,'1','test','10:19:05.031','2007-06-23 10:19:05.031',1,
0x00309f9284d44515a7969478bc2eb1a3,'00309F92-84D4-4515-A796-9478BC2EB1A3',1,
1,1,0x30,'1','xml') ;
end LOOP;