回复 5# 不点饣
BAT 也可以操作 SQL Server- @echo off
- REM 把下面的delete命令改成你想要执行的SQL命令
- >"C:\test.sql" echo delete from ua_task
- >>"C:\test.sql" echo delete from ua_tasklog
- "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe" -S "服务器名" -U "用户名" -P "密码" -d "数据库名" -i "C:\test.sql" >"C:\test.txt"
复制代码
|