34,594
社区成员
发帖
与我相关
我的任务
分享
/** 导入文本文件
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''
)