¹ØÓÚSQL server 2000ÎÊÌâ
¸ÕѧSQL server£¬ÎÒ°²×°ÁËSQL server 2000£¬µ«Ã»Óа²×°ÍêÈ«£¬Ö»ÓÐһЩ¹¦ÄÜ¿ÉÒÔÓ㬻¹Óкܶ๦Äܲ»ÄÜÓã¬ÌýËµÐ¶ÔØÊ±Ð¶ÔØ²»ÍêÈ«µÄ£¬ÒªÊÇÏëÖØ°²×°µÄ»°¾ÍÒªÖØÐ°²×°ÏµÍ³ÁË£¬ÊDz»ÊÇÕâÑù°¡£¿ÕâÑùºÜÂé·³°¡~~~ÒªÊÇÏ´ÎÔÙ²»Äܰ²×°ÍêÈ«Æñ²»ÊÇÓÖÒªÖØ×°ÏµÍ³~~
PS:SQL server ¿ÉÒÔ¸úʲôÁ¬ÔÚÒ»Æð×öÏîÄ¿°¡£¬³ýÁËÍøÒ³£¬javaÖ®Í⣬C#¿ÉÒÔÂ𣿿ÉÒԵϰ£¬¿ÉÒÔ×öÊ²Ã´ÄØ£¿
ÖØ×°ÏµÍ³??ûÌý˵¹ýSQLÐ¶ÔØ²»ÍêÈ«ÐèÒªÖØ×°ÏµÍ³µÄ
ÓÃÐ¶ÔØÖ®ºó²»ÍêÈ«,ɵ¹ÏʽµÄÇåÀí×¢²á±íÈí¼þ¶àµÄÊÇ,Ëæ±ãÕÒ¸öÇåÀíÏÂ×¢²á±í¾ÍÐÐ
ÇåÀíÒ»ÏÂ×¢²á±í,»¹ÓÐCÅÌĿ¼Îļþ,
ÔÙÖØÆô°²×°SQL
ÇåÀíÒ»ÏÂ×¢²á±í,»¹ÓÐCÅÌĿ¼Îļþ,
ÔÙÖØÆô°²×°SQL
²»ÓÃÖØ×°ÏµÍ³£¬Ö»Òª¶Ô×¢²á±í½øÐÐÐ޸ľͿÉÒÔÁË¡£
³¬¼¶ÍÃ×Ó ÓÅ»¯´óʦµÈ¶¼¿ÉÒÔÇåÀí×¢²á±í
Ïà¹ØÎÊ´ð£º
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
ÐèÇóÈçÏ£º
a±í:
p_id status
1 0
2 0
b±í
rec_id pid purchase_qty receive_qty flag
1 1 10 10 0
2 ......
Ò»¸öºÜÆæ¹ÖµÄÎÊÌâ
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'
--Ò»ÌõÊý¾Ý ......