<< Store procedure Use  IN,NOT IN keyword>>
Create procedure SP_Demo777
(

@Country varchar(max)

)
as
select * from Tbl_Country where CountryName in(@Country) and CountryName=@Country
return

<<See Video>>