select * from sometable 
where ID=isnull(@id,id) and name=isnull(@name,name) and sex=isnull(@sex,sex)

------解决方案--------------------

探讨


引用:
SQL code
select * from sometable
where ID=isnull(@id,id) and name=isnull(@name,name) and sex=isnull(@sex,sex)


请问：我的这三个参数是由外界赋值的，由函数参数传入，该怎么写呢？