--根据查询结果导出文本文件
EXEC master..xp_cmdshell 'bcp "select * from sms.dbo.sms_62" queryout C:\admin62.txt -c -S 19.16.192.15 -Uuser001 -P123'--文本文件导入到数据库BULK INSERT Test
FROM 'D:\Test.txt'
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)
select * from Test
EXEC master..xp_cmdshell 'bcp "select * from sms.dbo.sms_62" queryout C:\admin62.txt -c -S 19.16.192.15 -Uuser001 -P123'--文本文件导入到数据库BULK INSERT Test
FROM 'D:\Test.txt'
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)
select * from Test
declare @sql varchar(1000)
set @sql='bcp "数据库名.dbo.表名" in "文本文件路径" -c -q -U"用户名" -P"密码"'
exec master.xp_cmdshell @sql