spGet_ATHLETICS_CONTACTINFO

  CREATE PROCEDURE [dbo].[spGet_ATHLETICS_CONTACTINFO]
    @ID int = null
AS
SET NOCOUNT ON

if @ID<=0
set @ID=null

SELECT [ID], 
    [Phone], 
    [Email], 
    [Address],
    [ContactName]
FROM ATHLETICS_CONTACTINFO
WHERE [ID] = ISNULL(@ID, [ID])


SET NOCOUNT OFF