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

[Òý]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


Ïà¹ØÎĵµ£º

ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ


ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ
1¡¢´Ó΢ÈíÕ¾µãÉÏÏÂÔØqslice_setup.exe
2¡¢´ò¿ªQuery Analyzer£¬ÔËÐÐÒÔÏÂÓï¾ä£º
declare @a int
while (1<2)
begin
select @a=1
end
½«»á·¢ÏÖcpuÂíÉÏ´ïµ½100%
3¡¢´ò¿ªqlice.exe£¬½«·¢ÏÖsqlserver.exeµÄcpuÕ¼ÓÃÂʺܸߣ¬Ë«»÷½øÈ룬³öÐÐsqlserver.exeÖоßÌåÏß³ ......

ÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµÓÅ»¯ÍøÕ¾ÐÔÄÜ


ÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµÓÅ»¯ÍøÕ¾ÐÔÄÜ
Êý¾Ý¿â, »º´æ, SQLSERVER, ÐÔÄÜ
ºÜ¶àʱºò£¬ÎÒÃÇ·þÎñÆ÷µÄÐÔÄÜÆ¿¾±»áÊÇÔÚ²éѯÊý¾Ý¿âµÄʱºò£¬ËùÒÔ¶ÔÊý¾Ý¿âµÄ»º´æ·Ç³£ÖØÒª£¬ÄÇôÓÐûÓÐÒ»ÖÖ·½·¨£¬¿ÉÒÔʵÏÖSQL SERVERÊý¾Ý¿âµÄ»º´æ£¬µ±Êý¾Ý±íûÓиüÐÂʱ£¬¾Í´Ó»º´æÖжÁÈ¡£¬µ±ÓиüеÄʱºò£¬²Å´ÓÊý¾Ý±íÖжÁÈ¡ÄØ£¬´ð°¸Êǿ϶¨µÄ£¬Õâ ......

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

Ò»¡¢           SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºó ......

asp.netÁ¬½ÓSQL ºÍACCESSÊý¾Ý¿â

ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â 
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë: 
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+ ......

һЩSqlServerÓï¾ä

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ