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

sql Óï¾äÓÅ»¯ ÎÊÌ⣿ ÇóÖú£¡

SELECT ×Ö¶Î1
  from ±í  WHERE (...) AND ×Ö¶Î1=function()

×Ö¶Î1ÓпÉÄܵÄÖµ Ϊ 0 »òÕß -1
  function ·µ»Ø 0 »òÕß -1

ÕâÑùµÄËÙ¶ÈÌ«ÂýÁË  Çë¸ßÊÖ°ïæ
¶¨£¡


ÎÒд³ÉÕâÑù  ËٶȹûÈ»¿ìÁË

select ×Ö¶Î1 from ±í  where(...) and ×Ö¶Î1 in (select function() from dual)

лл£¡


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

SQL ¹ØÓÚ¶àÌõupdate

ÀýÈçÓÐ2¸ö±í Ò»¸öÊÇÔ±¹¤ÐÅÏ¢±í ±íÀïÓÐÃû×Ö ¹¤×ʵÈ×Ö¶Î Ò»¸öÊǹ«Ë¾²ÆÎñ±íÓРÿÔÂ×ÜÖ§³öµÈ×Ö¶Î

ÏÖÔÚÒª¸øÒ»¸öÔ±¹¤Õǹ¤×Ê 500RMB  ¾ÍҪд2Ìõ UPDATEÓï¾ä£¨¼ÙÉèÖ»ÓÐÁ½ÕÅ±í¡£Êµ¼Ê¿Ï¶¨Òª¸ü¶à£©

ÎÊ£ºÈçºÎ ......

ÇóÖú£ºSQLÓï¾ä

±í1£º
col1              col2
a                a.1
b                b.1
......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

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  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ