在sql server中正常执行的sql语句为何用ExecuteNonQuery不执行?
「已注销」 2007-12-29 05:19:28 源码如下
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = "Data Source = RENJINGLEI-PC\\SQLEXPRESS;User ID = sa; Password = ;";
SqlCommand sqlCmd = sqlConn.CreateCommand();
sqlConn.Open();
sqlCmd.CommandText = "insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','D:\\Database.mdb';'admin';'', Test)select * from Test";
int lineNum = sqlCmd.ExecuteNonQuery();
Console.WriteLine(lineNum);
sqlConn.Close();
}
}
}
sql语句本身在sql server 2005里运行正常,该程序未有异常,但就是不执行插入。
请各位高手赐教。