- @echo off
- >"C:\test.sql" echo set identity_insert question_title on //开启手动设置
- >>"C:\test.sql" echo insert into question_title (f_id,f_valid,f_questionTitle) values(6,5,'hello'); //手动的向数据库插入数据
- "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe" -S "服务器名" -U "用户名" -P "密码" -d "数据库名" -i "C:\test.sql" >"C:\test.txt"
复制代码
|