¼ÙʹÓбíA ¼ÙʹÓбíB
Name Exp_Money Name Storage Balance
ÕÅÈý 90 ÕÅÈý 1000 null
ÀîËÄ 30 ÕÔÎå 1000 null
ÀîËÄ 20 ËïÁù 500 null
ÕÔÎå 110 ÀîËÄ 1000 null
ËïÁù 300
ÕÔÎå 20
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
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 ......
±íÖеÄÒ»¸öÊôÐÔÁÐchoiceÓÐÁ½ÖÖ¿ÉÄܵÄÖµ£ºstringA,stringB£¬¶¼ÊÇ×Ö·û´®¡£
ÎÒÓÃÒ»¸öresult(stringÀàÐÍ£©´æ´¢Ñ¡ÔñµÄ½á¹û
SELECT * from tablename WHERE choice = res ......
±íÃû:ABC
select * from abc ÌáʾÕÒ²»µ½¶ÔÏó
select * from ABC ÕýÈ·.
Õâ¸ö´óСдÔÚÄÄÀïÉèÖõÄ?
ÒÔÇ°½¨µÄ¿âµ¹Ã»Õâ¸öÎÊÌâ.ºóÔÚ±¾ÉíÖØн¨Á¢Ò»Ð¿â.ÓÉÓÚ³ÌÐòÖлù±¾ÉÏȫΪСд.³ÌÐòÎÞ·¨ÔËÐÐ.È«ÊÇ´íÎóÌá ......