当生成的字符串是:IF Object_Id('Expense_ExpenseOrderItem') IS NOT NULL
SELECT Count(*) AS COUNT FROM Expense_ExpenseOrderItem WHERE TypeId = '5'怎么用正则表达式取到后半句“SELECT Count(*) AS COUNT FROM Expense_ExpenseOrderItem WHERE TypeId = '5'”。注:前半句括号中内容('Expense_ExpenseOrderItem') 是动态生成的。
SELECT Count(*) AS COUNT FROM Expense_ExpenseOrderItem WHERE TypeId = '5'怎么用正则表达式取到后半句“SELECT Count(*) AS COUNT FROM Expense_ExpenseOrderItem WHERE TypeId = '5'”。注:前半句括号中内容('Expense_ExpenseOrderItem') 是动态生成的。
SELECT Count(*) AS COUNT FROM Expense_ExpenseOrderItem WHERE TypeId = '5'";
Regex reg = new Regex(@"(?i)\bselect\b.*");
Response.Write(reg.Match(str).Value);