用存储过程代替 SQL IN的写法

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