打不死的心态活到老。

Sybase造数据

上一篇 / 下一篇  2007-08-01 00:11:28 / 个人分类：数据库

查看( 1032 ) / 评论( 0 ) / 评分( 0 / 0 )
建表：51Testing软件测试网 g z+iSnv4A-P

51Testing软件测试网4sY\^#Q%kV

CREATE TABLE "test"."testvar" (

/X*ouf/w'k0

.uk+h@:| e1u2KmE2m0       "bigint" bigint NULL DEFAULT autoincrement,

_%] S0\]4`;e0

c*s;uGh"SZ0       "binary" binary(1) NULL DEFAULT current database,51Testing软件测试网P;}W$ee@

ah$q6rVz-S5r'Kx0       "bit" bit NULL DEFAULT 12345,51Testing软件测试网;t3DqPmq

51Testing软件测试网0yG$u3Rdcj&V

       "char" char(5) NULL DEFAULT 'char',51Testing软件测试网,I,s0UMpyu9T0l

51Testing软件测试网9B4e2U*I2X+n cL~

       "CLOB" "CLOB" NULL DEFAULT current database,

j p.TB ^#zY#vy051Testing软件测试网BXh(T:J)PJX1s

       "date" date NULL DEFAULT current date,51Testing软件测试网"n6@9K(_ c"o;q1Pbe

51Testing软件测试网 E?!o8Hx

       "datetime" "datetime" NULL DEFAULT current timestamp,51Testing软件测试网bki sR

51Testing软件测试网S(y)kmX4xP

       "decimal" decimal(30,6) NULL DEFAULT autoincrement,51Testing软件测试网5Z@r#a*Ly-kP8{

51Testing软件测试网&la-{"V Anh

       "double" double NULL DEFAULT autoincrement,

7U?4xxLo|u0

;g%B xmt @0       "float" float NULL DEFAULT autoincrement,51Testing软件测试网` To v1|1Fl8j9A2B

0v$WLIi0       "image" "image" NULL DEFAULT current database,51Testing软件测试网!\U:B9Wyc ~0|

51Testing软件测试网gc"hA UNhv*M

       "integer" integer NULL DEFAULT autoincrement,

-|Q6h4ph0

/G#E D5S+r*`$R0       "long binary" long binary NULL DEFAULT current database,51Testing软件测试网^4Jf:Mu^5fA

6S^5j/~/y%Tl!}0       "long varchar" long varchar NULL DEFAULT current database,

ko(].M!v5tI051Testing软件测试网%tMUM ?Q

       "money" "money" NULL DEFAULT autoincrement,51Testing软件测试网1YYn1])|:cGM+_b4S

51Testing软件测试网#L8I2r$R mw7Q(L;OT

       "numeric" numeric(30,6) NULL DEFAULT autoincrement,51Testing软件测试网'jX8\%vuQ$WT

51Testing软件测试网 D@:H-k [:M\*M

       "oldbit" "oldbit" NULL DEFAULT autoincrement,

o7J8q1W_X H,~051Testing软件测试网~&^L V2J~%Y5C

       "real" float NULL DEFAULT autoincrement,

0UhFOl8Mq*I3~0

/o3}%]}8on2uk;i#w#c Z0       "smalldatetime" "smalldatetime" NULL DEFAULT current timestamp,

Yg_3HX0

-sf;l%\3y"C3ei-S ~0       "smallint" smallint NULL DEFAULT autoincrement,51Testing软件测试网s%q)b-_6O]:h

51Testing软件测试网C3l!d:jI5w)^1b

       "smallmoney" "smallmoney" NULL DEFAULT autoincrement,51Testing软件测试网b*M5bD'yN4gL

'`?M"{'x$t?0       "sysname" "sysname" NULL DEFAULT current database,

7A6{9c\.]051Testing软件测试网4QV9q-beA%_ `1?

       "text" "text" NULL DEFAULT 'text',51Testing软件测试网7i*J!e"{5[q#_

51Testing软件测试网4N[1uu5[G8g

       "time" time NULL DEFAULT current time,51Testing软件测试网$H7g.V6zg9NG a}0za

A%o*a)y7j1t Q5a0       "timestamp" timestamp NULL DEFAULT current timestamp,51Testing软件测试网 s.i2D&J2E|

51Testing软件测试网)I)c0Hq Rb0t l

       "tinyint" tinyint NULL DEFAULT autoincrement,

#rTj gire pL051Testing软件测试网8j+fk.`4c3A9j

       "uniqueidentifier" uniqueidentifier NULL DEFAULT '1234',

C6q4Wf v Z0

u;K H(~D4|"Io0       "uniqueidentifierstr" "uniqueidentifierstr" NULL DEFAULT current database,51Testing软件测试网Fa9t5p,^#Q q

51Testing软件测试网q]+@:i @}*]EF Hk%q

       "unsigned bigint" unsigned bigint NULL DEFAULT autoincrement,51Testing软件测试网@C8I9|,a(M2U

51Testing软件测试网ay3O1x8p'wp

       "unsigned int" unsigned int NULL DEFAULT autoincrement,51Testing软件测试网T&c3\Q7oa*s|m

oJ*E:GK\[0       "unsigned smallint" unsigned smallint NULL DEFAULT autoincrement,

vG;x+bSr_;m051Testing软件测试网5c|q)` w4Fd aJEl

       "varbinary" varbinary(1) NULL DEFAULT current database,51Testing软件测试网W8S6_H6i q `

,v"J1Op L)^0       "varchar" varchar(1) NULL DEFAULT 'varchar',

F@*Y.fuL/E1vK051Testing软件测试网d3S"Gh-N

       "xml" "xml" NULL DEFAULT 'xml'51Testing软件测试网uf_mI e

51Testing软件测试网.L9I5bAZD ?:r X

) IN "SYSTEM";51Testing软件测试网Zj.{@1k5ui;J

"k&M/sKO*gc0 

b-e&f"U]0

?&^c-_Y'Afe0插入一条数据：51Testing软件测试网"Y8lh#n @E6D m)r|

i O;R ^H.M E0insert into "test"."testvar" (

,AN7BJ sv6j0

!V;v%[1j;O,Et#q2J0"bigint","binary","bit","char","CLOB","date",

;yr.Nj*m(f0

&{7d!A Cz0"datetime","decimal","double","float",image,51Testing软件测试网Al,k2Xt

:L ed:?&W0"integer","long binary","long varchar","money",51Testing软件测试网 Ct7p{WC]

51Testing软件测试网2I:o6F-M5a'k/PX?n t

"numeric","oldbit","real","smalldatetime","smallint",51Testing软件测试网o/B0ip6g(m%j`&^ ~

hm\Q/{(CiT0"smallmoney","sysname","text","time","timestamp","tinyint",

(b8@pD3e Oe051Testing软件测试网5m*hmS+gX/N

"uniqueidentifier","uniqueidentifierstr","unsigned bigint",51Testing软件测试网8u1{1z {!~!G

(X`|a2P0"unsigned int","unsigned smallint","varbinary","varchar","xml")

V8K`TL)hh0

X ['r:? e9][-]+?0values(51Testing软件测试网z.D'{9dC;[Y,?

51Testing软件测试网 JpG(C.Q[

1,0x74,1,'char','<NCLOB>','2007-01-14',51Testing软件测试网_r @-x'Vm

7u/CZx])C ?0'2007-01-01 00:00:00.000',1.000000,1.0,1.0,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,51Testing软件测试网 Do|q Y`;O3}

51Testing软件测试网`FU5SC(ge0X

1,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,'1',1.0000,51Testing软件测试网[4J5^fFcw%P

51Testing软件测试网zeWX.x

1.000000,1,1.0,'2007-07-11 10:19:05.031',1,

JAv8u)I~:RC*r*h051Testing软件测试网'N%hd7bir3Q(?

1.0000,'1','test','10:19:05.031','2007-06-23 10:19:05.031',1,51Testing软件测试网5W{-hJaX

51Testing软件测试网 X*a5H3ZH!]7yu v^

0x00309f9284d44515a7969478bc2eb1a3,'00309F92-84D4-4515-A796-9478BC2EB1A3',1,51Testing软件测试网EeL L(R)G(I A&d

51Testing软件测试网_| U|3D3HD&w:^{

1,1,0x30,'1','xml') ;51Testing软件测试网{)n4}N%UZwcj

51Testing软件测试网8JAL\8Ju7fN

 

;[)oe'@_%Qa051Testing软件测试网-asXx.I(?3s

插入10000条数据

c}0ws`5G6Gx051Testing软件测试网/Xc+Y?/I

 

!|i5C4nd051Testing软件测试网*yU-U ]2h:{ UuL

WHILE (select count(*) from "test"."testvar") <= 10000 LOOP51Testing软件测试网*nD GA)K7@(O

S)KB4ks2b}V0insert into "test"."testvar" (51Testing软件测试网 u'_sM/jL

51Testing软件测试网D#X%D6zPLO(U

"bigint","binary","bit","char","CLOB","date",51Testing软件测试网 M[7i_ K5|5Zc

51Testing软件测试网Ks$l#JE]2^ R{$g

"datetime","decimal","double","float",image,51Testing软件测试网6x w/G2M @

51Testing软件测试网Uxcx|.yO[1vz*HO

"integer","long binary","long varchar","money",

uHg)@:H(i`7j0

[@1x/t_c0"numeric","oldbit","real","smalldatetime","smallint",51Testing软件测试网:NCg rmI9i

51Testing软件测试网b8OI A&R|9F

"smallmoney","sysname","text","time","timestamp","tinyint",51Testing软件测试网t)w1[ p3F s-i|

h*f-c%F bE0"uniqueidentifier","uniqueidentifierstr","unsigned bigint",

2R;SI,u%IMf1g"g!E051Testing软件测试网4wk*G8h{z

"unsigned int","unsigned smallint","varbinary","varchar","xml")51Testing软件测试网*nx8?)sU!bOB5^

51Testing软件测试网 i-B0T*e;qB }U

values(51Testing软件测试网3SW0yfAv

51Testing软件测试网\d3UCSW4rL-g#M

1,0x74,1,'char','<NCLOB>','2007-01-14',51Testing软件测试网#_]P7r~p|2u.|v:W.v W

51Testing软件测试网Y$?QDf+d6h

'2007-01-01 00:00:00.000',1.000000,1.0,1.0,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,51Testing软件测试网6_I_?s,W-J

51Testing软件测试网ym6]VB/}xAy

1,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,'1',1.0000,51Testing软件测试网$OQp7_y;Nya*M.E&f

S~8p"uT'Yrh01.000000,1,1.0,'2007-07-11 10:19:05.031',1,51Testing软件测试网c0|,T:Od Y

51Testing软件测试网8Ec-^O+@v W\Na

1.0000,'1','test','10:19:05.031','2007-06-23 10:19:05.031',1,51Testing软件测试网 EU_ O6s

%wg{+i&u(X.D!^+T00x00309f9284d44515a7969478bc2eb1a3,'00309F92-84D4-4515-A796-9478BC2EB1A3',1,51Testing软件测试网3L5PZP%I

51Testing软件测试网8@P{#gY7U4\

1,1,0x30,'1','xml') ;51Testing软件测试网A+J\p)DaI

51Testing软件测试网-h$a&H%x3V ? [

end LOOP;51Testing软件测试网4lfw!| u1@$HH

51Testing软件测试网/OB K0T6N3H


收藏 举报

TAG: 数据库

 

评分：0

我来说两句

Open Toolbar