62,041
社区成员
发帖
与我相关
我的任务
分享
select * from Students where (@Stu_No ='' or Stu_No=@Stu_No) and (@Stu_Name = '' or Stu_Name=@Stu_Name)
and (@Stu_IDNumber='' or Stu_IDNumber=@Stu_IDNumber)and(@Stu_Class ='' or Stu_Class = @Stu_Class)
and(@Stu_Birthday ='' or Stu_Birthday =@Stu_Birthday)
这是我之前做的,楼主可以参考