/** 导入文本文件
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’
)
sql 数据导出到txt
最新推荐文章于 2022-11-03 11:01:07 发布