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

Java--sql2000µÄ³ÌÐòÓÃÔÚsql2005

¸÷룬¸ø¿´¿´°É~~~Îҳ̶ȲÇë¶àµãÌáʾ¡£

Çé¿öÊǽ´µÄ£º
Ô­À´µÄ³ÌÐòÊÇÔÚsql2000Ï¿ª·¢µÄ£¬¸Ã³ÌÐò¾­¹ýºÜ¶à²âÊÔ¶øÇÒ¶¼Ó¦ÓÃÔÚsql2000Ï£¬Ã»ÓÐÎÊÌâ¡£¸Ã³ÌÐòÊÇJAVAµÄ¡£
ÏÖÔÚÎÒÓÃÁËsql2005£¬tomcatÆô¶¯Ê±Ã»ÎÊÌ⣬µ«ÊÇÔڵǼÁ¬½ÓÊý¾Ý¿âʱ¾Í»á±¨´í£¬±¨Á¬½ÓÊý¾Ý¿âÒì³£¡£

ÎҲ²âÊÇÁ½¸ö°æ±¾µÄÊý¾Ý¿âÁ´½Ó·½·¨²»Í¬£¬ÊÇÂð£¿ÏÖÔÚÎÒÖ»ÄÜ¿´µ½classÎļþ£¬²»Äܸü¸ÄÔ´Âë¡£ËùÒÔ£¬ÈçºÎÔÚ²»¸ü»»Êý¾Ý¿âµÄÇé¿öϽâ¾öÕâ¸öÎÊÌâÄØ£¿


ÎÒÔÚweb-inf/libÏÂҲûÓÐÕÒµ½sqljdbc.jar~ΪʲôÄØ£¿ºÃÓôÃÆ

ÓÐÇëÀîêÏ

¶ÔÁË£¬Òª²¹³ä¸öÇé¿ö£º

ÔÚÊý¾Ý¿âÖÐÒѾ­½¨Á¢ÁË±í£¬°²×°µÄʱºò½¨Á¢µÄ¡£Ö»ÊÇÔÚ°²×°Íê±ÏµÚÒ»´ÎµÇ¼ʱ¾Í»á³öÕâ¸ö¡£
¶ö~~»¹ÓУÂ/£Ó½á¹¹£¬Õâ¸öÓÐÓÃô......

±§Ç¸£¬¸÷룬¾­²éÎÒµÄsqlserverÆäʵÊÇ2000µÄ¡£¡£¡£
¿´ÆðÀ´²»ÊÇÊý¾Ý¿â°æ±¾ÎÊÌ⣬ÊÇÆäËû³ÌÐòµÄÎÊÌâ¡£

ºÇºÇ


Ïà¹ØÎÊ´ð£º

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

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

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

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøʱ¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

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