----------------------------------------------------------------------------------------
-- CityCustomers.sql
--
-- SQL statements for a simple stored procedure using the CAP database
-- used in examples in Database Principles, Programming, and Performance, Second Edition
--
-- by Alan G. Labouseur
--    www.Labouseur.com
----------------------------------------------------------------------------------------


Create Procedure CityCustomers
   @cityname varchar(20)
As
   select *
   from Customers
   where city = @cityname
go

exec CityCustomers 'Duluth'
go

exec CityCustomers 'Kyoto'
go

exec CityCustomers 'Newburgh'
go