摘要: declare @a nvarchar--set @a=''select * from students where (id between 1 and 5) and ((@a is null) or Name=@a)这样实现where 后面多条件查询就简单很多! 阅读全文
posted @ 2012-02-10 17:55 cuitsl 阅读(256) 评论(0) 推荐(0) 编辑
友情博客:大熊的外星球