select *
FROM OpenDataSource ('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...Sheet1$
select * from
OPENROWSET(
'SQLNCLI',
'Server=.\sqlexpress;Trusted_Connection=yes;',
'select * from t' )
-- ;EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;-- 开户权限
EXEC master..xp_cmdshell 'BCP t out c:\1.dat -c -U"sa" -P"123"'
EXEC master..xp_cmdshell 'BCP t -c -F 10 -L 13 -T'
--;EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 0;RECONFIGURE;--