打不死的心态活到老。

Sybase造数据

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

查看( 1035 ) / 评论( 0 ) / 评分( 0 / 0 )
建表：

/[ W[c B8khL0

,f5|5yYO0CREATE TABLE "test"."testvar" (

8TQ3olWO/\I051Testing软件测试网u3k0} S Y9H6sg

       "bigint" bigint NULL DEFAULT autoincrement,51Testing软件测试网n\VVym0aY

51Testing软件测试网m0j U']$KQ3e;n

       "binary" binary(1) NULL DEFAULT current database,51Testing软件测试网.h c_Tn|y8V

51Testing软件测试网,iE~1n {w

       "bit" bit NULL DEFAULT 12345,

^ w\;U;ub D051Testing软件测试网@M7w s\.{ FEN

       "char" char(5) NULL DEFAULT 'char',

\9Y9p{r!j/G tD^051Testing软件测试网Jh+b2Q8A

       "CLOB" "CLOB" NULL DEFAULT current database,51Testing软件测试网)aZ s!} a]-ku h

51Testing软件测试网 _.gx7~1p

       "date" date NULL DEFAULT current date,51Testing软件测试网'XK'n3oa0njr D

51Testing软件测试网$a)cR8h&cuN

       "datetime" "datetime" NULL DEFAULT current timestamp,51Testing软件测试网;b.cAUfcb MS7Z

!f8m;jdI1^ y&As0       "decimal" decimal(30,6) NULL DEFAULT autoincrement,51Testing软件测试网S!m0~x }

51Testing软件测试网2B)O"x;D2S7u:W-^_8T

       "double" double NULL DEFAULT autoincrement,

c'A0~*[}051Testing软件测试网t7OW N t"k

       "float" float NULL DEFAULT autoincrement,

5[.Q-Iw!n;q6F.P051Testing软件测试网0t7o5\J^

       "image" "image" NULL DEFAULT current database,

4@}th8Zy#h$h{0

7g)f$]f/Y Rq{0       "integer" integer NULL DEFAULT autoincrement,

qR/dM5~ O'I/[ c_051Testing软件测试网a0G!P&x3u wZ(j

       "long binary" long binary NULL DEFAULT current database,

(I8vw+E f3`051Testing软件测试网9E7|CPU B5[.Zo]

       "long varchar" long varchar NULL DEFAULT current database,

I;hb[0Jt)M0

(B$xo7~J]0       "money" "money" NULL DEFAULT autoincrement,

6oyjq X @:G Q X051Testing软件测试网 zNLj/Uq w A I

       "numeric" numeric(30,6) NULL DEFAULT autoincrement,51Testing软件测试网nS)?_*E,nx9x R.z(k

51Testing软件测试网!e3CT]c1s

       "oldbit" "oldbit" NULL DEFAULT autoincrement,51Testing软件测试网BB0B` @eV

51Testing软件测试网h+g1p'Gt&I

       "real" float NULL DEFAULT autoincrement,

6c@6F(KS.a051Testing软件测试网/Mr*Du"F6A6c ^*`,M

       "smalldatetime" "smalldatetime" NULL DEFAULT current timestamp,

otOG%i h]I%~z0

k$G U|)fe0       "smallint" smallint NULL DEFAULT autoincrement,51Testing软件测试网{4y ~km-V5et

51Testing软件测试网!rbW N$HNOY

       "smallmoney" "smallmoney" NULL DEFAULT autoincrement,

!jQawt4^,x Z5L0

'r|5Ix'w in$c0       "sysname" "sysname" NULL DEFAULT current database,

m+^XV4c051Testing软件测试网.W l i%K!@*@4j p

       "text" "text" NULL DEFAULT 'text',51Testing软件测试网&]3t~y z

{&Wj$C4| y"s.f0       "time" time NULL DEFAULT current time,51Testing软件测试网!a:uY)k5Z#S$bj

*}0].D {V(as:g0       "timestamp" timestamp NULL DEFAULT current timestamp,

A-E2kV(QV051Testing软件测试网OU0y h$| FS1V

       "tinyint" tinyint NULL DEFAULT autoincrement,

!dradIGc051Testing软件测试网+o/a'l Tx'Wf

       "uniqueidentifier" uniqueidentifier NULL DEFAULT '1234',51Testing软件测试网D7Ew E9vN#j1? N

51Testing软件测试网J*A0v KC-Ot@A$q

       "uniqueidentifierstr" "uniqueidentifierstr" NULL DEFAULT current database,

3GQh"SqL}051Testing软件测试网HLAU]0k@

       "unsigned bigint" unsigned bigint NULL DEFAULT autoincrement,

+X2|]}3yI%? F Y051Testing软件测试网Nc7]s ~V3Tf7x

       "unsigned int" unsigned int NULL DEFAULT autoincrement,51Testing软件测试网^hA8Gd[+@O,~

w:c(m4m)[e @ u \0       "unsigned smallint" unsigned smallint NULL DEFAULT autoincrement,

j:?(\-gv*L#Z-S^0

0{\ Sj~?U0       "varbinary" varbinary(1) NULL DEFAULT current database,51Testing软件测试网 Z-N`+DA.F

6W0F3v9fr CU3v0T0       "varchar" varchar(1) NULL DEFAULT 'varchar',

6\'w k&t~8af051Testing软件测试网 bC(rB*f2_i

       "xml" "xml" NULL DEFAULT 'xml'

(LS"S5t#u*QG051Testing软件测试网Du:g} V1H3d x*^a,P

) IN "SYSTEM";51Testing软件测试网.]K4UD8](\aA4C.{

51Testing软件测试网ngR ~AZ f4\8`

 51Testing软件测试网6i5F,@k] X0Qo3R

51Testing软件测试网/he;t$nS'l4c!O

插入一条数据：

)p]%S+G [2o2cN^051Testing软件测试网VbI'Us%Mf-oPs

insert into "test"."testvar" (51Testing软件测试网V/mEJ9I d

1t$\u4| b L/Vtz)gZ0"bigint","binary","bit","char","CLOB","date",51Testing软件测试网#qnGGO

51Testing软件测试网H;} o {asN:w_

"datetime","decimal","double","float",image,51Testing软件测试网E5gzZ)o.sa\$az;hB

~)h&]/VW E)_Q:B0"integer","long binary","long varchar","money",

*he"mA)XsN051Testing软件测试网2D'G(i.z b C1nQ

"numeric","oldbit","real","smalldatetime","smallint",

#O-| n V`;t051Testing软件测试网G ^agr IQ1Yi

"smallmoney","sysname","text","time","timestamp","tinyint",

!f*E:D;W6ch1U2U0

5B!RgbuNo X0"uniqueidentifier","uniqueidentifierstr","unsigned bigint",

KUt0|9Uq?3Xta3X0

m,IA?h0"unsigned int","unsigned smallint","varbinary","varchar","xml")51Testing软件测试网z[j M9nz

|.rT}(v:h4|lJ0values(

!Z:c/F.R(\_ ep051Testing软件测试网5e{K4Q%o

1,0x74,1,'char','<NCLOB>','2007-01-14',

4ke,O w t_WK051Testing软件测试网O WH,H@0t&D*plX%w

'2007-01-01 00:00:00.000',1.000000,1.0,1.0,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,51Testing软件测试网s;l%pI Y9t

a.Vn2e&_G8C01,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,'1',1.0000,

@S;T#j_K~051Testing软件测试网/?/B8|/T'm)h2o g)f/YF

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

9[9j!sZi,^|n0

ik*T[0x5uAr$d01.0000,'1','test','10:19:05.031','2007-06-23 10:19:05.031',1,

J4O'aS Ju0

.i X uwh,N ZA00x00309f9284d44515a7969478bc2eb1a3,'00309F92-84D4-4515-A796-9478BC2EB1A3',1,

~3Z;sBO051Testing软件测试网Jx1rPTg Y

1,1,0x30,'1','xml') ;51Testing软件测试网9fF.D:o0i"X3a2P

51Testing软件测试网2tr`L4C!Y%h

 51Testing软件测试网q9]x Jt$q dD E+B*Q2fP1d

51Testing软件测试网l?&ZRL

插入10000条数据51Testing软件测试网6onge:Ks n!Gy

d i){LgW-n0 

1}7Dc%w,y*~wx[C051Testing软件测试网GgW;Qmi9{]&h

WHILE (select count(*) from "test"."testvar") <= 10000 LOOP51Testing软件测试网5d)pk}f^(j Yz:?9n

51Testing软件测试网2Y6G)inC5Q

insert into "test"."testvar" (

4^ AR B6`"wg4\051Testing软件测试网Q*kF8yp~\

"bigint","binary","bit","char","CLOB","date",

`1YG x1s;n3ij051Testing软件测试网 v\X G{ w yl4}

"datetime","decimal","double","float",image,

w VD^ HM1DU051Testing软件测试网4H i?v.\x1k

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

7rX6LO ~051Testing软件测试网rSm0|z

"numeric","oldbit","real","smalldatetime","smallint",

%y B*w1? te051Testing软件测试网|*C rGm CU)uC

"smallmoney","sysname","text","time","timestamp","tinyint",51Testing软件测试网`q4|#JG;]:D

51Testing软件测试网qW/f(U#_$I)a!G jJ Q

"uniqueidentifier","uniqueidentifierstr","unsigned bigint",

D3E?i4f'X4kn-Dr0

+jT8Z0w7p})Kwqq0"unsigned int","unsigned smallint","varbinary","varchar","xml")

p,\F&h1jv0

feC*xs1wg0values(51Testing软件测试网&B l sy*CV#BH

51Testing软件测试网xt}]+V.g#pu

1,0x74,1,'char','<NCLOB>','2007-01-14',51Testing软件测试网'SAUz^ A"nV

'd?y'A#Zf|p0'2007-01-01 00:00:00.000',1.000000,1.0,1.0,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,

q,[@\zQ(Q051Testing软件测试网!J{1TI3?r

1,0x30303330394639322d383444342d343531352d413739362d393437384243324542314133,'1',1.0000,51Testing软件测试网 a{h3jw

(vw(M-[my%u9I\01.000000,1,1.0,'2007-07-11 10:19:05.031',1,51Testing软件测试网#Kkr!M%j b#D

8W,I:C;bU{(|,`e _z01.0000,'1','test','10:19:05.031','2007-06-23 10:19:05.031',1,51Testing软件测试网6E i }@+L|u3\/g

}m#DV } L8C00x00309f9284d44515a7969478bc2eb1a3,'00309F92-84D4-4515-A796-9478BC2EB1A3',1,

^p1pl2t051Testing软件测试网E?E B~ [P \;V4o

1,1,0x30,'1','xml') ;

4`4?pp$RN!A8j0

*Dooz1p.t&MlI0end LOOP;

7_3P+g)t0yK051Testing软件测试网2H_0W|w3O6B"h


收藏 举报

TAG: 数据库

 

评分：0

我来说两句

Open Toolbar