string tmpFile = Path.GetTempFileName();
string argument = string.Format(@" -S {0} -d {1} -i ""{2}"" -o ""{3}""",
ServerName, DatabaseName, fileName, tmpFile);
// append user/password if not use integrated security
if (!connection.IsIntegratedSecurity)
argument += string.Format(" -U {0} -P {1}", User, Password);
var process = Process.Start("sqlcmd.exe", argument);
process.StartInfo.UseShellExecute = false;
process.StartInfo.CreateNoWindow = true;
process.Start();
while (true)
{
// wait for the process exits. The WaitForExit() method doesn't work
if (process.HasExited)
break;
Thread.Sleep(500);
}
C#调用SQLCMD去批量执行sql脚本
最新推荐文章于 2020-12-08 19:00:34 发布