MicrosoftSqlServer2005导入导出语句集锦VIP免费

1/******* 导出到 excelEXEC master..xp_cmdshell ’bcp SettleDB.dbo.shanghu out c:temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""’/*********** 导入 ExcelSELECT *FROM OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,’Data Source= "c:test.xls";User ID= Admin;Password= ;Extended properties= Excel 5.0’)...xactionsSELECT 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 * fromOPENROWSET(’MICROSOFT.JET.OLEDB.4.0’,’dBase IV;HDR= NO;IMEX= 2;DATABASE= C:’,’select * from [客户资料 4.dbf]’)--*/--/* dBase III 文件select * fromOPENROWSET(’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]’)2--*//**************导入 DBF 文件****************/select * from openrowset(’MSDASQL’,’Driver=Microsoft Visual FoxPro Driver;SourceDB=e:VFP98data;SourceType=DBF’,’select * from customer where country != "USA" order by country’)go/***************** 导出到 DBF ***************/如果要导出数据到已经...