[Òý]SQLServerºÍAccess¡¢ExcelÊý¾Ý´«Êä¼òµ¥×ܽá
http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔÒò£¬¿Í»§ÒÔÇ°µÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾³£ÐèÒª·ÃÎÊÎı¾Êý¾Ý¿âÖеÄÊý¾Ý£¬ËùÒԾͻá²úÉúÕâÑùµÄÐèÇó¡£Ç°¶Îʱ¼ä³ö²îµÄÏîÄ¿£¬¾ÍÊÇÃæÁÙÕâÑùµÄÒ»¸öÎÊÌ⣺SQLServerºÍVFPÖ®¼äµÄÊý¾Ý½»»»¡£
ÒªÍê³É±êÌâµÄÐèÒª£¬ÔÚSQLServerÖÐÊÇÒ»¼þ·Ç³£¼òµ¥µÄÊÂÇé¡£
ͨ³£µÄ¿ÉÒÔÓÐ3ÖÖ·½Ê½£º1¡¢DTS¹¤¾ß 2¡¢BCP 3¡¢·Ö²¼Ê½²éѯ
DTS¾Í²»ÐèҪ˵ÁË£¬ÒòΪÄÇÊÇͼÐλ¯²Ù×÷½çÃ棬ºÜÈÝÒ×ÉÏÊÖ¡£
ÕâÀïÖ÷Òª½²ÏºóÃæÁ½ÃÇ£¬·Ö±ðÒԲ顢Ôö¡¢É¾¡¢¸Ä×÷Ϊ¼òµ¥µÄÀý×Ó£º
ÏÂÃæ·Ï»°¾Í²»ËµÁË£¬Ö±½ÓÒÔT-SQLµÄÐÎʽ±íÏÖ³öÀ´¡£
Ò»¡¢SQLServerºÍAccess
1¡¢²éѯAccessÖÐÊý¾ÝµÄ·½·¨£º
select * from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from serv_user')
»ò
select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\DB2.mdb";User ID=Admin;Password=')...serv_user
2¡¢´ÓSQLServerÏòAccessдÊý¾Ý£º
insert into OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from Accee±í')
select * from SQLServer±í
»òÓÃBCP
master..xp_cmdshell'bcp "serv-htjs.dbo.serv_user" out "c:\db3.mdb" -c -q -S"." -U"sa" -P"sa"'
ÉÏÃæµÄÇø±ðÖ÷ÒªÊÇ£ºOpenRowSetÐèÒªmdbºÍ±í´æÔÚ£¬BCP»áÔÚ²»´æÔÚµÄʱºòÉú³É¸Ãmdb
3¡¢´ÓAccessÏòSQLServerдÊý¾Ý£ºÓÐÁËÉÏÃæµÄ»ù´¡£¬Õâ¸ö¾ÍºÜ¼òµ¥ÁË
insert into SQLServer±í select * from
OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from Accee±í')
»òÓÃBCP
master..xp_cmdshell'bcp "serv-htjs.dbo.serv_user" in "c:\db3.mdb" -c -q -S"." -U"sa" -P"sa"'
4¡¢É¾³ýAccessÊý¾Ý£º
delete from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from serv_user')
where lock=0
5¡¢ÐÞ¸ÄAccessÊý¾Ý£º
update OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from serv_user')
set lock=1
SQLServerºÍAccess´óÖ¾ÍÕâô¶à¡£
¶þ¡¢SQLServerºÍExcel
1¡¢ÏòExcel²éѯ
select * from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;HD
Ïà¹ØÎĵµ£º
ת×Ô
http://topic.csdn.net/t/20050110/09/3711952.html
accessÖÐʱ¼äÒªÓÃ#,²»ÊÇË«ÒýºÅ
select * from kc where rq < #2000-01-01# and rq>#2002-01-01#
²»ÒªÓÃbetween,ËüµÄЧÂÊÌ©µÍ
ʹÓÃ# ¶ø²»ÊÇ ......
1
.¾ø¶ÔÖµ
S:
select
abs
(
-
1
) value
O:
select
abs
(
-
1
) value
from
dual
¡¡¡¡
2
.È¡Õû(´ó)
S:
select
ceiling
(
-
1.001
) value
O:
select
ceil(
-
1.001
) value
from
d ......
http://www.cnblogs.com/byeday/archive/2009/10/04/1578034.html
ÎÊÌ⣺“Failed to access IIS metabase”½â¾ö
2009-08-14 17:03
ÔÒò£ºIISûÓÐ×¢²á
½â¾ö°ì·¨£º
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ ......
ÔÎÄ£ºhttp://blog.sina.com.cn/s/blog_5fdcf5c90100fher.html
AccessÊý¾Ý¿â“×Ô¶¯±àºÅ”×ֶιéÁã
AccessÊý¾Ý¿â“×Ô¶¯±àºÅ”Êý¾ÝÀàÐÍÊÇÒ»¸ö·Ç³£ÊµÓõÄÀàÐÍ£¬Ëü¿ÉÒԺܷ½±ãµØ°ïÖúÎÒÃÇÍê³É±êʶ²»Í¬¼Ç¼IDµÄ¹¤×÷¡£µ«ÊÇÓÉÓÚJETÒýÇæµÄÌØÐÔ£¨SQL serverʹÓÃT-SQL£©£¬µ±ÎÒÃÇÔÚAccessÊý¾Ý¿âijÕűíÖÐÖ´ÐÐÁËɾ ......