/*导入记事本到数据库表中*/
BULK INSERT tbTemp FROM 'H:/Export.txt'WITH (
DATAFILETYPE = 'widechar',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '/n',
KEEPNULLS,
MAXERRORS =100
)
/*导入到数据库表中*/
EXEC master..xp_cmdshell 'bcp carinsurance..tbTemp in H:/test.txt -c -t"," -S"." -U"sa" -P"123" '
/*导出数据到记事本中*/
EXEC master..xp_cmdshell 'bcp "select top 1000 * from carinsurance..Insurance" queryout H:/test.txt -c -t"," -S"." -U"sa" -P"123" '