:::@echo off
:::echo ------------------ 启动SQL数据库服务 ------------------
:::如果没有启动sql服务,会先启动sql服务。“$”后面的是数据库实例名
::net start mssql$127.0.0.1
:::echo _____________________________________________________
:::echo.
:::echo _____________________________________________________
echo ------------------ 执行T-SQL语句 ----------------
sqlcmd -S"127.0.0.1" -U"name" -P"password" -d"xxx1" -Q"SELECT * FROM [xxx1].[xxx2].[xxx3]" -s" " -o C:\Users\data\result.txt -h"-1"
echo ------------------ 任务执行完毕 ------------------
pause