SQLÓï¾äµ¼Èëµ¼³ö´óÈ«

/*******  µ¼³öµ½excel
exec master..xp_cmdshell ’bcp settledb.dbo.shanghu out c:\temp1.xls -c -q -s"gnetdata/gnetdata" -u"sa" -p""’
/***********  µ¼Èëexcel
select *
from opendatasource( ’microsoft.jet.oledb.4.0’,
  ’data source="c:\test.xls";user id=admin;password=;extended properties=excel 5.0’)...xactions
select cast(cast(¿ÆÄ¿±àºÅ as numeric(10,2)) as nvarchar(255))+’¡¡’ ת»»ºóµÄ±ðÃû
from opendatasource( ’microsoft.jet.oledb.4.0’,
  ’data source="c:\test.xls";user id=admin;password=;extended properties=excel 5.0’)...xactions
/** µ¼ÈëÎı¾Îļþ
exec master..xp_cmdshell ’bcp dbname..tablename in c:\dt.txt -c -sservername -usa -ppassword’
/** µ¼³öÎı¾Îļþ
exec master..xp_cmdshell ’bcp "dbname..tablename" out c:\dt.txt -c -sservername -usa -ppassword’
´Ë¾äÐè¼ÓÒýºÅ
»ò
exec master..xp_cmdshell ’bcp "select * from dbname..tablename" queryout c:\dt.txt -c -sservername -usa -ppassword’
µ¼³öµ½txtÎı¾£¬ÓöººÅ·Ö¿ª
exec master..xp_cmdshell ’bcp "¿âÃû..±íÃû" out "d:\tt.txt" -c -t ,-u sa -p password’
bulk insert ¿âÃû..±íÃû
from ’c:\test.txt’
with (
    fieldterminator = ’;’,
    rowterminator = ’\n’
)
--/* dbase ivÎļþ
select * from
openrowset(’microsoft.jet.oledb.4.0’
,’dbase iv;hdr=no;imex=2;database=c:\’,’select * from [¿Í»§×ÊÁÏ4.dbf]’)
--*/
--/* dbase iiiÎļþ
select * from
openrowset(’microsoft.jet.oledb.4.0’
,’dbase iii;hdr=no;imex=2;database=c:\’,’select * from [¿Í»§×ÊÁÏ3.dbf]’)
--*/
--/* foxpro Êý¾Ý¿â
select * from openrowset(’msdasql’,
’driver=microsoft visual foxpro driver;sourcetype=dbf;sourcedb=c:\’,
’select * from [aa.dbf]’)
--*/
/**************µ¼ÈëdbfÎļþ****************/
select * fr