SQL的INSERT语句中嵌入SELECT语句
蜀雁 2014-06-20 04:35:48 string SqlAccountKind = "INSERT INTO dbo.AccountKind VALUES(" + txtAccountID.Text.Trim() + ", \'" + txtAccountName.Text.Trim() + "\', 1, " +
"SELECT MK_Id FROM dbo.MeterKind WHERE MK_Name = \'" + txtAccountName.Text.Trim() + "\', " +
txtSysKey.Text.Trim() + ", " + txtMainNo.Text.Trim() + "," + txtBuyLimit.Text.Trim() + ", " +
txtPrestorage.Text.Trim() + ", " + txtWarning.Text.Trim() + ", 0, " +
txtOverdraught.Text.Trim() + ", 0, 0, -1, 0)";
这个是要执行的INSERT语句,其中有项内容通过 "SELECT MK_Id FROM dbo.MeterKind WHERE MK_Name = \'" + txtAccountName.Text.Trim() + "\语句从另一张表中查询,在最终执行时,报错:“SELECT”附近有语法错误。请问大神:这里能不能嵌套,若能,这语句该怎样修改?谢谢。