Sqlserver2000造数据

xT7^|0Q B
a0 51Testing软件测试网t?%s-v_,u_/I;pk

@AX*V7Y~0F0Sqlserver2000建表语句

'l7s q8z0o*S8h \0if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestVar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

9NI{Am5e0drop table [dbo].[TestVar]

wgRN5_t0GO51Testing软件测试网#nY,a.^/U\ f

;F1i&c*Wx5M0 51Testing软件测试网 `;qwa"a(C9U,m

CREATE TABLE [dbo].[TestVar] (51Testing软件测试网O~T*k6wL

[aInt] [int] IDENTITY (1, 1) NOT NULL ,

*[%jzrn{;P_^N4P0[aBigint] [bigint] NULL ,51Testing软件测试网:K o6P)~` @3x

fFgxBHXKy0[aBinnary] [binary] (50) NULL ,

[aBit] [bit] NULL ,51Testing软件测试网!GH%p#X2yG R

7K\5jFpf3p OwI.Q0[aChar] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,

[aDatetime] [datetime] NULL ,

[aDecimal] [decimal](18, 0) NULL ,51Testing软件测试网;p
EGNP0YxrVP.o

sSV&]JP;d7}z V0[aFloat] [float] NULL ,51Testing软件测试网A&B1v1W(`

0Z IR"z U3m
?0[aImage] [image] NULL ,

,k]edu Ml^/dz0[aMoney] [money] NULL ,51Testing软件测试网6C)L K [,zoEJ

7H7Y }0@|(\Y:i0[aNChar] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,51Testing软件测试网/MN0KImk"a

[aNText] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,51Testing软件测试网]h ]gN U

[aNumeric] [numeric](18, 0) NULL ,51Testing软件测试网@6Zs;n5^'h.R-s

'z
Z6|O"A1sOT
i0[aNvarchar] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,51Testing软件测试网hF{(R)[ a^Le

3S3x;Q_"[,Y0[aReal] [real] NULL ,

[aSmalldatetime] [smalldatetime] NULL ,

[aSmallInt] [smallint] NULL ,

[aSmallMoney] [smallmoney] NULL ,

[aSql_Variant] [sql_variant] NULL ,

[aText] [text] COLLATE Chinese_PRC_CI_AS NULL ,

x I]Q$TB0[aTimesTamp] [timestamp] NULL ,

MwJ(t_$w'K5s%D0[aTinYint] [tinyint] NULL ,51Testing软件测试网h oA4M!w{6E0o3Q

[aUniQueidentifier] [uniqueidentifier] NULL ,

[aVarBinary] [varbinary] (50) NULL ,

k\"w%v0hJ&l0[aVarchar] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]51Testing软件测试网}%ol&~'r|Q:qu

y.L)Q0C
y!L~ e:P0GO51Testing软件测试网_z4hF-Jj2L

6b`U(};SxE!x0s0 51Testing软件测试网,Vh,C;g mR^vo1J

*_4u8h$|+gaBN0b"w0 51Testing软件测试网 oX |^*Y$Y#owq9E EDQ

0H i;c0R0ii7ii"I9^RC0插入1条记录示例

(n c!@]Oh%MYC0INSERT INTO51Testing软件测试网*h\6P9r7sx7]9s

[testBase].[dbo].[TestVar]( [aBigint],51Testing软件测试网HF,X
YQ(l0J.{i&K

)SS |5e _N:J,O5c'}g0 [aBinnary], [aBit], [aChar], [aDatetime],51Testing软件测试网7n,H|+T$vR/o;]

6ze6FBT$Op_0[aDecimal], [aFloat], [aImage], [aMoney],51Testing软件测试网Mnr'A)e p

#T r:\(P4k]1Oz0[aNChar], [aNText], [aNumeric], [aNvarchar],51Testing软件测试网)cA0W#^afB/RC

h kibV0 [aReal], [aSmalldatetime], [aSmallInt], [aSmallMoney],

[s@6y@Q'T0[aSql_Variant], [aText],51Testing软件测试网+T4UYga$LW%` D

 [aTinYint], [aUniQueidentifier], [aVarBinary], [aVarchar])

&H}dB"AYB`0VALUES( 1,51Testing软件测试网$L:B&|4`F)U:E&u;_'fY

 CAST( 123456 AS BINARY(4) ), '0101', 'aChar', getdate(),51Testing软件测试网!W3@+uo0z1f(HJc-L

M@4d,nhdxF?0 132.00, 123.00,'abcdefghijk' , 123.00,51Testing软件测试网8O3K2HY&\?O

S9_c T$l9Q5z
]0'aNChar', 'aNText,ntext,>', 12300.00,'<aNvarchar,nvarchar(50),>',

CAST(300 AS real) , getdate(), 123.123, 123.00,51Testing软件测试网-Trx&l
A}y.P0t7rn z"\

convert(nchar(20), N'AbCdEfGhIjKlMnOpQrStUvWxYz'), '<aText,text,>',

 51Testing软件测试网'ID_-k q$m+_1|

+{*Wn4~4?0CAST(3 AS TinYint),NEWID() , CAST( REPLICATE( 0x20, 128 ) AS varbinary(32) ),

'<aVarchar,varchar(50),>')51Testing软件测试网Bqh;tuc^

 51Testing软件测试网nV(p'n s7L8T\Jj

izG
CD.][]\0循环插入10000条数据示例51Testing软件测试网8l\,V%iv;B

cO`*B*wR
@^;d0While (select Count(*) from  TestVar)<10000

;^6S^ j{C0begin51Testing软件测试网'd a3H/x%}Q2ZZ+t

INSERT INTO [testBase].[dbo].[TestVar]( [aBigint],

 [aBinnary], [aBit], [aChar], [aDatetime],51Testing软件测试网(Eyn0q)IL1l

[aDecimal], [aFloat], [aImage], [aMoney],

[aNChar], [aNText], [aNumeric], [aNvarchar],

 [aReal], [aSmalldatetime], [aSmallInt], [aSmallMoney],

YF_&g7G|%D0[aSql_Variant], [aText],51Testing软件测试网b/ghq;|] s

:^[rW6O1dx1Q h0 [aTinYint], [aUniQueidentifier], [aVarBinary], [aVarchar])51Testing软件测试网,L+]K7X.w VgE

Om&E6Zc-Low:s0VALUES( 1, CAST( 123456 AS BINARY(4) ), '0101', 'aChar', getdate(),51Testing软件测试网+qC uv2n7rm@3{

 132.00, 123.00,'abcdefghijk' , 123.00,51Testing软件测试网 k*? P/GYe+v^

,Ikf%xm4E$Sz.U0'aNChar', 'aNText,ntext,>', 12300.00,'<aNvarchar,nvarchar(50),>',51Testing软件测试网,p\qA[F)]ys

T O
]"Y3F4r }k0CAST(300 AS real) , getdate(), 123.123, 123.00,51Testing软件测试网JR6_ B.N,F3}]9jM

convert(nchar(20), N'AbCdEfGhIjKlMnOpQrStUvWxYz'), '<aText,text,>',

*`;v3Qu}g{9b)r2? Q0CAST(3 AS TinYint),NEWID() , CAST( REPLICATE( 0x20, 128 ) AS varbinary(32) ),51Testing软件测试网ShzI u q[A

'<aVarchar,varchar(50),>')

CONTINUE51Testing软件测试网g!To4V\T

~;tl;[ykY0End51Testing软件测试网4C4CY+qW4Y&zV