Oracle:
private const string SQL_SELECT_EVENTBYNAME = "SELECT * FROM UTACCIES_UPLOAD_EVENT WHERE EVENTNAME = :EVENTNAME";
private const string PARM_EVENT_NAME = @"EVENTNAME";
Sql Server:
private const string SQL_SELECT_EVENTBYNAME = "SELECT * FROM UTACCIES_UPLOAD_EVENT WHERE EVENTNAME = @EVENTNAME";
private const string PARM_EVENT_NAME = "@EVENTNAME";
注意:在oracle中,sql语句中,参数之前要用 ':' (冒号), 在定义参数时, @要放在引号之外
在Sql server, sql语句中,参数之前要用'@', 在定义参数时, @要放在引号之内