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

¹ØÓÚSQL server 2000ÎÊÌâ

¸ÕѧSQL server£¬ÎÒ°²×°ÁËSQL server 2000£¬µ«Ã»Óа²×°ÍêÈ«£¬Ö»ÓÐһЩ¹¦ÄÜ¿ÉÒÔÓ㬻¹Óкܶ๦Äܲ»ÄÜÓã¬ÌýËµÐ¶ÔØÊ±Ð¶ÔØ²»ÍêÈ«µÄ£¬ÒªÊÇÏëÖØ°²×°µÄ»°¾ÍÒªÖØÐ°²×°ÏµÍ³ÁË£¬ÊDz»ÊÇÕâÑù°¡£¿ÕâÑùºÜÂé·³°¡~~~ÒªÊÇÏ´ÎÔÙ²»Äܰ²×°ÍêÈ«Æñ²»ÊÇÓÖÒªÖØ×°ÏµÍ³~~

PS:SQL server ¿ÉÒÔ¸úʲôÁ¬ÔÚÒ»Æð×öÏîÄ¿°¡£¬³ýÁËÍøÒ³£¬javaÖ®Í⣬C#¿ÉÒÔÂ𣿿ÉÒԵϰ£¬¿ÉÒÔ×öÊ²Ã´ÄØ£¿
ÖØ×°ÏµÍ³??ûÌý˵¹ýSQLÐ¶ÔØ²»ÍêÈ«ÐèÒªÖØ×°ÏµÍ³µÄ

ÓÃÐ¶ÔØÖ®ºó²»ÍêÈ«,ɵ¹ÏʽµÄÇåÀí×¢²á±íÈí¼þ¶àµÄÊÇ,Ëæ±ãÕÒ¸öÇåÀíÏÂ×¢²á±í¾ÍÐÐ

ÇåÀíÒ»ÏÂ×¢²á±í,»¹ÓÐCÅÌĿ¼Îļþ,
ÔÙÖØÆô°²×°SQL

ÇåÀíÒ»ÏÂ×¢²á±í,»¹ÓÐCÅÌĿ¼Îļþ,
ÔÙÖØÆô°²×°SQL

²»ÓÃÖØ×°ÏµÍ³£¬Ö»Òª¶Ô×¢²á±í½øÐÐÐ޸ľͿÉÒÔÁË¡£

³¬¼¶ÍÃ×Ó  ÓÅ»¯´óʦµÈ¶¼¿ÉÒÔÇåÀí×¢²á±í


Ïà¹ØÎÊ´ð£º

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

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ÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......

ÇóÒ»sql¡¾Ð»Ð»¡¿ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
a±í:
 p_id status  
  1 0
  2 0
b±í
rec_id pid purchase_qty receive_qty flag
1 1 10 10 0
2 ......

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ºÅ