SQL Server 2000,操作系统XP:
create table test_Level
(
CardNO varchar(10),
CardName varchar(20),
JF float
)
insert into test_Level
select 'A0001','Tom',100
union all
select 'B0012','Cat',250.8
union all
select 'DF23','Jerry',60
union all
select 'Tim100','Master',1005.6
select *
from test_Level
A0001
Tom
100.0
B0012
Cat
250.80000000000001
DF23
Jerry
60.0
Tim100
Master
1005.6
很怪啊,我还插入了1005.6但是没变
|