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

SQL Server 2000 SP4ÓбØÒªÉý¼¶KBô£¿

ĿǰÎÒʹÓõÄÊÇSQL Server 2000 SP4(8.00.2039)¡£
ºóÀ´½ÏÕæÆðÀ´²ÅÖªµÀÓõĸöÈ˰档

ÕâÊÇÒòΪÓöµ½Ò»¸öÎÊÌ⣬ÔÚ´óÁ¿·ÃÎÊÊý¾Ý¿âµÄʱºò£¬Íⲿ³ÌÐò³öÏÖ³ÖÐøÁ¬½Óʧ°ÜµÄÏÖÏó¡£
½«Íⲿ³ÌÐòÈ«²¿×é¼þ¶¼ÖØÆôÒ»±ßÖ®ºó£¬Õý³£ÁË¡£

ºóÀ´ÔÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄÈÕÖ¾²é¿´Æ÷ÀӦÓóÌÐòÏÂÕÒµ½ºÜ¶àÒÔϵġ°ÐÅÏ¢¡±£º
17055-ʼþID-
17052:
SQL Server ÒÑΪ 8 ¸ö²¢·¢²éѯ¶øÓÅ»¯¡£15 ¸ö²éѯ³¬¹ýÁË´ËÏÞÖÆ£¬Òò¶øÐÔÄÜ¿ÉÄÜ»áÊܵ½²»Á¼Ó°Ïì¡£

¡­¡­
¾­google²éÕÒ£¬ËµÊÇÒòΪ¸öÈ˰æ(ÓÐÒ»¸ö²¢·¢¹¤×÷¸ººÉµ÷¿ØÆ÷£¬¿ÉÔÚ²¢·¢Ö´ÐÐ5¸öÒÔÉϵÄÅú´¦ÀíʱÏÞÖÆÊý¾Ý¿âÒýÇæµÄÐÔÄÜ)µÄ¡£
ÐèÒªÉý¼¶ÖÁÆóÒµ°æ²ÅÄܽâ¾ö¸ÃÎÊÌâ¡£

ÓÚÊÇÎÒÔÚÁíһ̨·þÎñÆ÷ÉϲâÊÔÁ˰²×°SQL2000¸öÈ˰æ+SP4(2039)£¬Éý¼¶µ½ÆóÒµ°æ£¬ÈÔÈ»ÊÇSP4(8.00.2039)£¬¡­¡­ÏÖÔÚÎÊÌâÊÇ£¬ÎÒÊÇ·ñÐèÒªÔÚ´Ë»ù´¡ÉÏ£¬Éý¼¶SP4ÒÔÉÏµÄÆäËûKB¸üÐÂÄØ£¿»òÕß˵ÊÇ·ñ±ØÒªÉý¼¶SP4ÒÔÉÏµÄÆäËûKB¸üУ¿
ÓбØÒª

Éý¼¶µ½sql server 2000 ÆóÒµ°æ + sp4¼´¿É.

Èç¹û»¹²»ÐÐ,¾ÍÒª¿¼ÂÇʹÓÃsql server 2005»òÆäËûÊý¾Ý¿â,ÈçoracleµÈÁË.

´òspµÄÄ¿µÄÊǽâ¾öһЩsql server ±¾ÉíµÄbug»òÊÇǷȱ
Äã¿ÉÒÔ¿´Ò»ÏÂsp4ºóµÄkbµÄÄ¿µÄÊÇ·ñ¶ÔÄãÓбØÒª£¬²»¾Í¿ÉÒÔ¾ö¶¨ÁËÂð£¿

±Ï¾¹¸öÈ˰æµÄ¹¦Äܲ»ÈçÆóÒµ°æµÄ¹¦ÄÜÇ¿´ó.

ÓÐÇ®µÄ»°»¹ÊÇ»»ÆóÒµ°æµÄ±È½ÏºÃ ¸öÈ˰æµÄÓÐËûÒ»¶¨µÄ¾ÖÏÞÐÔ

¡£¡£¡£¡£UP

ÒýÓÃ
ÓÐÇ®µÄ»°»¹ÊÇ»»ÆóÒµ°æµÄ±È½ÏºÃ ¸öÈ˰æµÄÓÐËûÒ»¶¨µÄ¾ÖÏÞÐÔ

ÎÒÓõͼÊDz»»¨£¤µÄ¶«¶«:)

ÒýÓÃ
Éý¼¶µ½sql server 2000 ÆóÒµ°æ + sp4¼´¿É.

Èç¹û»¹²»


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sql ½ØÈ¡×Ö·û´®

ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

SQLʱ¼ä¶ÎÎÊÌâ

Ò»¸öºÜÆæ¹ÖµÄÎÊÌâ 
SQL code
select * from Gprs_DataInof 
--¿ÉÒԲ鵽ËùÓеÄÊý¾Ý
select * from Gprs_DataInof where DataTime between 1900-10-16 1:01:00' and '2009-10-20 1:01:00'
--Ò»ÌõÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ