怎么写关于“IN”操作符的SQL语句的参数化命令

2025-05-08 01:16:23
推荐回答(1个)
回答1:

string sqltext = "exec('SELECT * FROM user WHERE id IN (?)')";
OdbcCommand oCmd = new OdbcCommand(sqltext, oConn);
oCmd.Parameters.Add("UserId", OdbcType.Int).Value = "777,888,999";