MicrosoftSqlServer2005导入导出语句大全..pdfVIP

SQL 语句导入导出大全 /******* 导出到 excel EXEC master..xp_cmdshell bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -SGNETDATA/GNETDATA -Usa -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 /*动态文档名 declare @fn varchar(20),@s varchar(1000) set @fn = c:\test.xls set @s =Microsoft.Jet.OLEDB.4.0, Data Source=+@fn+;User ID=Admin;Pas