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

¡¶Êý¾Ý¿âϵͳ¸ÅÄî¡·Õâ±¾ÊéÈëÃÅSQL¿ÉÒÔÂð£¿

ÎÒÊǸöÍêȫûÓÐÊý¾Ý¿â¾­ÑéµÄÐÂÊÖ£¬»áC/C++¡£
ºÃÏñSQL ServerÔÚÕй¤Ê±±È½ÏÓõÄÉÏËùÒÔÏëѧ¡£
ÎÒÓà ¡¶Êý¾Ý¿âϵͳ¸ÅÄî¡· ÈëÃÅ¿ÉÒÔÂ𣬻ò¶¼ÓиüºÃµÄ½Ì²Ä£¿

SQLSERVER 2000±¦µä
SQL Server¾«»ª

ÈëÃÅ Äã¿ÉÒÔËæ±ãÕÒ±¾Êé
Íâ¼ÓÁª»ú´ÔÊé

Â¥ÉÏ˵µÄ¶Ô£¬Áª»ú´ÔÊéÆäʵÊÇ×îºÃµÄ¡£

SQLSERVER 2005±¦µä


ÒѾ­°²×°2005Áª»ú´ÔÊ飬лл´ó¼Ò£¡


Ïà¹ØÎÊ´ð£º

²»Ã÷°×µÄSQL×¢ÈëÎÊÌâ

ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò

ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......

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

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

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

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

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

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

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

ÊÇ ......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

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