sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),执行速度慢的要死，但是如果把(xxf>0 and xxfwzf <>0 )，这两个条件，改任何一个，速度都远比加两个要快，就算是记录数要多，也没有用，奇了个怪了，不知道是怎么回事，我把v_ddxx的视图贴出来
SELECT d_id, d_psz, d_bdrq, d_hdzs, d_smjz, d_bxf, d_zcf, d_sfqs, d_xcf, d_shf, d_yqdhrq, dbfy, g_gsmc, d_ssbm, d_sfsc, d_gsid, d_ddms, d_fhflxr,
d_fhflxdh, d_mdd, g_yyjsff, bmmc, d_ntime, d_czy, d_sfd, g_ssbm, jsfsmc, d_skfs, d_shfdw, d_shflxr, d_shflxdh, d_shflxdz, d_je, tydh, d_xxfsh,
d_tffsh, d_jsd, d_ztsh, u_xm, g_hsxs, jssl, hwjs, zyf, ysxjje, yshfje, ystfje, xxfyzf, CASE WHEN d_skfs = 97 OR
d_skfs = 112 THEN isnull(d_je, zyf) ELSE 0 END - ISNULL(ystfje, 0) AS wtfje, CASE WHEN d_skfs = 109 THEN isnull(d_je, zyf) WHEN (d_skfs = 112) AND
(isnull(zyf, 0) - isnull(d_je, zyf)) > 0 THEN (isnull(zyf, 0) - isnull(d_je, zyf)) ELSE 0 END - ISNULL(yshfje, 0) AS whfje, CASE WHEN (d_skfs = 97 OR
&nb
sql table表有个文本类型的a字段，存储的内容全部是数字，例如2009001，2008578这样的格式；b字段文本类型，存的也是数字例如 001，123
asp里面 strday=100，strb=001
我想读出，从a字段的数字按大到小的� ......
