22,209
社区成员
发帖
与我相关
我的任务
分享
bulk insert test--test为表名
from 'E:\Test.txt'
with(
FIELDTERMINATOR = ' ',--值的间隔符
ROWTERMINATOR = '\n'
)
/** 导入文本文件 */
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'
)
bulk insert test
from 'E:\Test.txt'
with(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)