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

Microsoft SQL Server 2005 JDBC Driver °æ±¾ÎÊÌâ

Microsoft SQL Server 2005 JDBC Driver  Õâ¸öÇý¶¯´ó¼ÒÓÐÓùýÂð£¿ÓÃʲô°æ±¾ºÅ¡£Î¢Èí¹ÙÍøÓÐ1.1µÄ»¹ÓÐ2.0µÄ£¬ÎÒÓõÄIDEÊÇJBuilder9
ÏÖÔÚÓÃ2.0µÄ°É£¬È¥Î¢ÈíÍøÕ¾ÏÂÔؼ´¿É¡£Á¬½Ó×Ö·û´®ºÍÒÔÇ°ÉÔÓв»Í¬£¬¿ÉÒÔËÑÒ»ÏÂÀ²¡£


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

ÇóÒ»¸ö¸ßÄѶȵÄSQLͳ¼ÆÃüÁî

Ô­À´±í½á¹¹Îª£º

  ʱ¼ä    Àà ÐÍ  ÊýÁ¿
2009-1-2  ëÒ  23 
2009-1-2  ëÒ  11 
2009-1-2  ÃÞÒ  3 
2009-1-3  ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

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

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

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

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


ÎÒд³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ