Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ææ¹ÖµÄSQLÓï¾ä

½ñÌì¿´±ðÈ˵ijÌÐò£¨pb9+oracle£©£¬·¢ÏÖÀïÃæÓÐÒ»SQLÕâÑùдµÄ
SELECT a,b
INTO :li_va:li_ia, :li_vb:li_ib
from table
WHERE ....
£»

È»ºóPB´úÂëÀïÓÐÕâÑùµÄÅжÏ
IF li_ib = -1 or li_vb = 0 THEN
  ...........
end if

²»Ã÷°×£¬Çë½Ì´ó¼Ò¡£
a¡¢bÁ½×Ö¶ÎÊÇnumberÐÍ
ÄÄÀï²»Ã÷°×£¿
ÏÈȡֵ£¬Èç¹ûaµÄÖµÊÇ-1  »òÕßbµÄÖµÊÇ0 ¾ÍÖ´ÐÐÌõ¼þ

xuamÇë×ÐϸÔÙ¿´£¬ÄãÓÐÁ½¸ö´íÎó
1.û¿´Çå³þSQLÓï¾äÖеıäÁ¿ÊÇÔõôдµÄ
2.¡°Èç¹ûaµÄÖµÊÇ-1  »òÕßbµÄÖµÊÇ0¡±ÕâÑù˵ÊÇ´íÎóµÄ

INTO :li_va:li_ia, :li_vb:li_ib ,


Í·Ò»¼ûÕâÑùµÄ£¡

ÒýÓÃ
xuamÇë×ÐϸÔÙ¿´£¬ÄãÓÐÁ½¸ö´íÎó
1.û¿´Çå³þSQLÓï¾äÖеıäÁ¿ÊÇÔõôдµÄ
2.¡°Èç¹ûaµÄÖµÊÇ-1  »òÕßbµÄÖµÊÇ0¡±ÕâÑù˵ÊÇ´íÎóµÄ



±àÒëÄܲ»ÄÜͨ¹ýÏÈ£¿ 

±àÒ뵱ȻÄÜͨ¹ý......

INTO :li_va:li_ia, :li_vb:li_ib Ҳû¼û¹ýÕâÑùµÄ£¬Â¥Ö÷×Ô¼ºÐ´¸ömessagebox£¬¿´¿´li_vaÊDz»ÊÇ=li_ia£¬li_vb=li_ib²»Èû£¬Èç¹ûÒ»Ñù£¬ÄǾʹú±í°Ña£¬bÖµ·Ö±ð¸³¸øÉÏÃæÁ½¸ö±äÁ¿Èû

°ï¶¥

ÒýÓÃ
INTO :li_va:li_ia, :li_vb:li_ib Ҳû¼û¹ýÕâÑùµÄ£¬Â¥Ö÷×Ô¼ºÐ´¸ömessagebox£¬¿´¿´li_vaÊDz»ÊÇ=li_ia£¬li_vb=li_ib²»Èû£¬Èç¹ûÒ»Ñù£¬ÄǾʹú±í°Ña£¬bÖµ·Ö±ð¸³¸øÉÏÃæÁ½¸ö±äÁ¿Èû


²»ÊÇÕâÑù¡£
×òÌìÎÒ¾Í×öÁËÊÔÑ飬²»¹Ü×Ö¶ÎaÊÇ0»ò¸º»òÕý£¬li_vaµÃµ½×ֶεÄÖµ£¬li_iaÊÇ0¡£

²»ÊÇÕâÑù¡£
×òÌìÎÒ¾Í×öÁËÊÔÑ飬²»¹Ü×Ö¶ÎaÊÇ0»ò¸º»òÕ


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ