在winform中需要执行sqlserver脚本来创建数据库,用streamreader读取,SqlCommand执行,但总提示go附加有语法错误,如果去掉go的话,语句执行不了,提示找不到AA数据库,sql语句如下:
USE master
GOCREATE DATABASE AA
ON
( NAME = StoreManager_dat,
FILENAME = 'D:\StoreManager.mdf')
LOG ON
( NAME = 'StoreManager_log',
FILENAME = 'D:\StoreManager_log.ldf');
GOUSE AA
GO
USE master
GOCREATE DATABASE AA
ON
( NAME = StoreManager_dat,
FILENAME = 'D:\StoreManager.mdf')
LOG ON
( NAME = 'StoreManager_log',
FILENAME = 'D:\StoreManager_log.ldf');
GOUSE AA
GO
ON
( NAME = StoreManager_dat,
FILENAME = 'D:\StoreManager.mdf')
LOG ON
( NAME = 'StoreManager_log',
FILENAME = 'D:\StoreManager_log.ldf');
USE AA
GO这样可以吗?
new string[]{"GO\r\n", "GO ", "GO\t"}, StringSplitOptions.RemoveEmptyEntries );
foreach (string c in commands)
{
command = new SqlCommand(c, masterConnection);
command.ExecuteNonQuery();
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
finally
{
masterConnection.Close();
}
}
代码来自:
Incorrect Syntax near 'GO'... SqlCommand.ExecuteNonQuery();
http://blogs.msdn.com/b/onoj/archive/2008/02/26/incorrect-syntax-near-go-sqlcommand-executenonquery.aspx