if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([name] varchar(6),[team] varchar(20),[num1] int,[num2] int)
insert [tb]
select '陈婉仪','东华西分行连小莉组',4,1 union all
select '陈婉仪','建设分行叶剑敏组',9,0 union all
select '陈婉仪','淘金分行刘桂贤组',3,0 union all
select '邓海莲','海珠中分行潘柳组',5,4 union all
select '邓海莲','应元分行吴木坤组',3,2 union all
select '邓海莲','百灵路分行曾庆倍组',1,0 union all
select '何庆祥','滨江东分行唐湘组',2,1 union all
select '何庆祥','百灵路分行朱洁片组',7,0 union all
select '黄景元','中海名都分行陈银伍组',1,1 union all
select '黄景元','中海名都分行赵桃生组',3,3 union all
select '黄景元','海联分行杨健萍组',5,1 union all
select '黄景元','新港西分行范文学组',1,0 union all
select '黄景元','新港西分行黄景元组',4,0 union all
select '廖振刚','农林下路商铺何杰君组',1,0 union all
select '刘荣','公益路分行宋小清组',3,1 union all
select '刘荣','雍华廷分行辛金明组',8,1 union all
select '刘荣','金碧分行刘荣组',6,0 union all
select '吴苏彬','江南西分行吴苏彬组',2,0
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
小弟我用ADO连接SQL server 2000数据库，然后在DBGrid中显示，现在想把在DBGrid中查询到的数据iPlot作图，请问如何实现在DBGrid中的数据读取，读出的数据是STRING类型的，如何有效的转变成数据库中所存储的DOUBLE类� ......
