SqlParameter一个变量对应多个参数的问题
qiujg 2018-04-09 11:18:54 select * from tt where name1 like @name or name2 like @name or name3 like @name
list.Add(new SqlParameter("@name", "张"));
这样执行不出结果
改为:
select * from tt where name1 like @name or name2 like @name or name3 like @name
list.Add(new SqlParameter("@name", "张"));
list.Add(new SqlParameter("@name", "张"));
list.Add(new SqlParameter("@name", "张"));
也不行
必须改为下面的?
select * from tt where name1 like @name1 or name2 like @name2 or name3 like @name3
list.Add(new SqlParameter("@name1", "张"));
list.Add(new SqlParameter("@name2", "张"));
list.Add(new SqlParameter("@name3", "张"));
这个可以。
请问为什么?