try
{
SQLServer.GetConnnection("Data Source=MRHOU;Initial Catalog=Store;Integrated Security=True");
string sql ="delete * from 入库表";
SqlCommand com = new SqlCommand(sql,SQLServer.conn);
com.ExecuteNonQuery(); }
catch (SqlException se)
{
MessageBox.Show(se.Message);
}
finally
{
SQLServer.CloseConnection();
}
为什么提示*附近有语法错误呢
{
SQLServer.GetConnnection("Data Source=MRHOU;Initial Catalog=Store;Integrated Security=True");
string sql ="delete * from 入库表";
SqlCommand com = new SqlCommand(sql,SQLServer.conn);
com.ExecuteNonQuery(); }
catch (SqlException se)
{
MessageBox.Show(se.Message);
}
finally
{
SQLServer.CloseConnection();
}
为什么提示*附近有语法错误呢
再加上表的名称,通常需要加上个where条件,否则就都删除了
Delete from table1