USE pubs
GO

CREATE PROCEDURE GetPubAuth(@state CHAR(2))
AS
SELECT * FROM pubs..Publishers WHERE State = @state;
SELECT * FROM pubs..Authors WHERE State = @state;
GO

exec GetPubAuth 'UT'
GO

CREATE INDEX pub_state ON pubs..Publishers(state)
GO

exec GetPubAuth 'CA'
GO


