用存储过程代替 SQL IN的写法
2013-04-18 16:54 kellweke 阅读(190) 评论(0) 编辑 收藏 举报select count(*) from [Users] where address in ('北京','广州')
creat procedure count_user as begin declare @a int declare @b int select @a=count(1) from [Users] where address ='北京' select @b=count(1) from [Users] where address='广州' select tatal=@a+@b end