¡¶Êý¾Ý¿âϵͳ¸ÅÄî¡·Õâ±¾ÊéÈëÃÅSQL¿ÉÒÔÂð£¿
ÎÒÊǸöÍêȫûÓÐÊý¾Ý¿â¾ÑéµÄÐÂÊÖ£¬»áC/C++¡£
ºÃÏñSQL ServerÔÚÕй¤Ê±±È½ÏÓõÄÉÏËùÒÔÏëѧ¡£
ÎÒÓà ¡¶Êý¾Ý¿âϵͳ¸ÅÄî¡· ÈëÃÅ¿ÉÒÔÂ𣬻ò¶¼ÓиüºÃµÄ½Ì²Ä£¿
SQLSERVER 2000±¦µä
SQL Server¾«»ª
ÈëÃÅ Äã¿ÉÒÔËæ±ãÕÒ±¾Êé
Íâ¼ÓÁª»ú´ÔÊé
Â¥ÉÏ˵µÄ¶Ô£¬Áª»ú´ÔÊéÆäʵÊÇ×îºÃµÄ¡£
SQLSERVER 2005±¦µä
ÒѾ°²×°2005Áª»ú´ÔÊ飬лл´ó¼Ò£¡
Ïà¹ØÎÊ´ð£º
ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò
ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......