Sqlserver2000造数据

n*N0p-_g4M wo d6g e0Sqlserver2000建表语句51Testing软件测试网rE0Gr5T+Qm

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestVar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)51Testing软件测试网T,N%w#UFc*f ]i6Y|8{[

drop table [dbo].[TestVar]51Testing软件测试网"AM S iv1X9T"ZM;ox

Vf"a/L?/mf.x0GO

 51Testing软件测试网'U|ZK U l1Y

CREATE TABLE [dbo].[TestVar] (

[aInt] [int] IDENTITY (1, 1) NOT NULL ,51Testing软件测试网D#z1s-b"YGu$R[
K

[aBigint] [bigint] NULL ,

[aBinnary] [binary] (50) NULL ,51Testing软件测试网W0R.~]h#y(_O%E

[aBit] [bit] NULL ,

+KF0d-Vbw G0[aChar] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,51Testing软件测试网bi4C6Z-`-\7s

Sm7wlw7sjy&z"j0[aDatetime] [datetime] NULL ,51Testing软件测试网$J.M"u`Z j@5Q(e

[aDecimal] [decimal](18, 0) NULL ,51Testing软件测试网$K(fI Ia7fpz"q.b"})H

-s {-bN$J o9O7Y3d7G O0[aFloat] [float] NULL ,

htIP-S4pxr/W0[aImage] [image] NULL ,

[aMoney] [money] NULL ,51Testing软件测试网?'J^NE*}z l

.IazV%H#A0[aNChar] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,51Testing软件测试网7P Su"_i:M6n~

[aNText] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,

}3fk'o(Pm W0PS0[aNumeric] [numeric](18, 0) NULL ,

[aNvarchar] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[aReal] [real] NULL ,51Testing软件测试网9x]
b OHMY

Q~7n7l\4?A{.W0[aSmalldatetime] [smalldatetime] NULL ,51Testing软件测试网+v
N
}|-i\S'lTC

axLI\+v0[aSmallInt] [smallint] NULL ,

!w3F$`el(|-o~0[aSmallMoney] [smallmoney] NULL ,

;m AP0N
w(s-QD;[0[aSql_Variant] [sql_variant] NULL ,51Testing软件测试网3q hf~lT4V)\5x

[aText] [text] COLLATE Chinese_PRC_CI_AS NULL ,51Testing软件测试网HZ*P
G-~

[aTimesTamp] [timestamp] NULL ,

n-gZ Q to0[aTinYint] [tinyint] NULL ,51Testing软件测试网f6[m7i0m,O.U u9~

+|*AX*G;|#\0[aUniQueidentifier] [uniqueidentifier] NULL ,51Testing软件测试网1]s+`@rk?}'z"n

Fa*Wzu
I0[aVarBinary] [varbinary] (50) NULL ,

[aVarchar] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL51Testing软件测试网 mP|y\ eG Ip:`

e-aM)[ _M*k0) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]51Testing软件测试网"spM!b0q(y
N

B IvnD0GO51Testing软件测试网kB B&| g g

:FS1q e*B0 51Testing软件测试网|Y@VO/I

5}y(EI$aB1i0插入1条记录示例51Testing软件测试网tt!xDd

4n%^-x)]p9TWv}0INSERT INTO

QY%n xJb0rM9w0[testBase].[dbo].[TestVar]( [aBigint],51Testing软件测试网[3s9@M2~QkLbcbZi

 [aBinnary], [aBit], [aChar], [aDatetime],

y0Ddf YMy'M#LI@0[aDecimal], [aFloat], [aImage], [aMoney],

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

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

v.UK/}Yz0[aSql_Variant], [aText],

 [aTinYint], [aUniQueidentifier], [aVarBinary], [aVarchar])51Testing软件测试网7P+r h G'K$zhMUr

nt)tdCYQ2|2]
jR0VALUES( 1,51Testing软件测试网.b1R
i)S0Dv&@4Y&tRL

 CAST( 123456 AS BINARY(4) ), '0101', 'aChar', getdate(),51Testing软件测试网vW[9~Ox

 132.00, 123.00,'abcdefghijk' , 123.00,

'aNChar', 'aNText,ntext,>', 12300.00,'<aNvarchar,nvarchar(50),>',51Testing软件测试网l_"Rl ^G1I

-?/uRl!Ej.M/{U}0Z0CAST(300 AS real) , getdate(), 123.123, 123.00,51Testing软件测试网+b|X3\:f*\/u0E

.a`#nHB)N`J(V0convert(nchar(20), N'AbCdEfGhIjKlMnOpQrStUvWxYz'), '<aText,text,>',51Testing软件测试网3XqS3t{]F;]

}
\OO |:Du0 51Testing软件测试网;vu] ~{H*z-j

CAST(3 AS TinYint),NEWID() , CAST( REPLICATE( 0x20, 128 ) AS varbinary(32) ),

)Dx0z
[r0'<aVarchar,varchar(50),>')

7kRw4}0kl7pdW6^M0 51Testing软件测试网#s*TCfZ$s8Gm
x

"p kx]3[C[j\0循环插入10000条数据示例51Testing软件测试网$D!W:]xR

While (select Count(*) from  TestVar)<1000051Testing软件测试网f)ll9u6blt

begin51Testing软件测试网L|.b1wF\c1G-n ]

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

I},e"H^(G$t*tX0 [aBinnary], [aBit], [aChar], [aDatetime],

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

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

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

[aSql_Variant], [aText],51Testing软件测试网)\S&b{H DH l8UhS

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

%qF0h8D M o_3C,Z@0VALUES( 1, CAST( 123456 AS BINARY(4) ), '0101', 'aChar', getdate(),51Testing软件测试网5aY[.z~1a2v

 132.00, 123.00,'abcdefghijk' , 123.00,51Testing软件测试网}3z_0H Rel

F)rjp O]0'aNChar', 'aNText,ntext,>', 12300.00,'<aNvarchar,nvarchar(50),>',51Testing软件测试网`9c _ I-JQw~i

u+_.B+ok$o0CAST(300 AS real) , getdate(), 123.123, 123.00,

V/LXF?3dy0convert(nchar(20), N'AbCdEfGhIjKlMnOpQrStUvWxYz'), '<aText,text,>',51Testing软件测试网x,omsy?

0x$R&wI-HH;],c0CAST(3 AS TinYint),NEWID() , CAST( REPLICATE( 0x20, 128 ) AS varbinary(32) ),

'<aVarchar,varchar(50),>')51Testing软件测试网B)a\SKo!F

sz,a2YUY
te q)I9i&\{0CONTINUE51Testing软件测试网^?j*bx

End