DOS下通过批处理执行sql命令

通过批处理执行sql命令：

 

1. Restore.bat文件内容：

 

osql  -E -S -i C:/TempDB/Restore.txt

 

 

2. Restore.txt文件内容：

use master

if exists (select * from sysdevices where name='TruckDB')

       EXEC sp_dropdevice 'TruckDB'

Else

       EXEC sp_addumpdevice 'disk','TruckDB', 'C:/Program Files/Microsoft SQL Server/MSSQL/Data/TruckDB.mdf'

 

restore database TruckDB

from disk='c:/TempDB/TruckDB'

with replace

 

 

 单表导出数据到txt:

 

/*导入*/

 

EXEC master..xp_cmdshell 'bcp "test..mintest" in d:/mintest2.txt -c -Sd02 -Usa -P'

 

/*导出*/

EXEC master..xp_cmdshell 'bcp "test..min" out d:/mintest2.txt -c -Sd02 -Usa -P'