��USE [Austin] GO /****** Object: StoredProcedure [dbo].[MyProc] Script Date: 05/08/2012 17:27:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Ken Bragg -- Create date: -- Description: -- ============================================= ALTER PROCEDURE [dbo].[MyProc] -- Add the parameters for the stored procedure here @ADDRESSID int, @COUNTY int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT * from dbo.ADDRESS_POINTS where ADDRESSID = @ADDRESSID and COUNTY = @COUNTY END