代码
USE
[
MYDBTest
]
GO
/*
***** 对象: Table [dbo].[DepositTran] 脚本日期: 05/06/2010 21:15:34 *****
*/
SET
ANSI_NULLS
ON
GO
SET
QUOTED_IDENTIFIER
ON
GO
CREATE
TABLE
[
dbo
]
.
[
DepositTran
]
(
[
ID
]
[
int
]
IDENTITY
(
1
,
1
)
NOT
NULL
,
[
Name
]
[
nvarchar
]
(
20
) COLLATE Chinese_PRC_CI_AS
NOT
NULL
,
[
Deposit
]
[
float
]
NOT
NULL
,
[
UpdateTime
]
[
datetime
]
NOT
NULL
,
CONSTRAINT
[
PK_Transaction
]
PRIMARY
KEY
CLUSTERED
(
[
ID
]
ASC
)
WITH
(IGNORE_DUP_KEY
=
OFF
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
declare
@i
int
set
@i
=
1
while
@i
<=
100000
begin
insert
into
DepositTran(Name,Deposit,UpdateTime)
values
(
‘
周菲菲
‘
,
500
,
‘
2009-08-08
‘
)
set
@i
=
@i
+
1
end
GO
declare
@i
int
set
@i
=
1
while
@i
<=
100000
begin
insert
into
DepositTran(Name,Deposit,UpdateTime)
values
(
‘
费佳杰
‘
,
1100
,
‘
2009-09-18
‘
)
set
@i
=
@i
+
1
end
GO
declare
@i
int
set
@i
=
1
while
@i
<=
100000
begin
insert
into
DepositTran(Name,Deposit,UpdateTime)
values
(
‘
周建飞
‘
,
1500
,
‘
2009-09-28
‘
)
set
@i
=
@i
+
1
end
GO
declare
@i
int
set
@i
=
1
while
@i
<=
300000
begin
insert
into
DepositTran(Name,Deposit,UpdateTime)
values
(
‘
金刚波
‘
,
2500
,
‘
2009-12-08
‘
)
set
@i
=
@i
+
1
end
GO
declare
@i
int
set
@i
=
1
while
@i
<=
400000
begin
insert
into
DepositTran(Name,Deposit,UpdateTime)
values
(
‘
马腾
‘
,
3500
,
‘
2010-02-08
‘
)
set
@i
=
@i
+
1
end
GO