hi
create procedure procedureName(
@cityId int
)
As
your Query like this
BEGIN
SELECT MemberId, Name as MemberName, City.Name as CityName
FROM Member INNER JOIN CITY ON Member.CityId = City.CityId where CityId=@cityId
END
--execute procedure
--pass cityId
--exec procedureName 1