spAddUpdate_ATHLETICS_CONTACTINFO

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@Phone	nvarchar(15)	IN
@Email	nvarchar(256)	IN
@Address	nvarchar(1024)	IN
@ContactName	nvarchar(256)	IN

Definition

Copy


  CREATE PROCEDURE [dbo].[spAddUpdate_ATHLETICS_CONTACTINFO]
    @ID int output,
    @Phone nvarchar(15),
    @Email nvarchar(256),
    @Address nvarchar(1024),
    @ContactName nvarchar(256)
AS
SET NOCOUNT ON
IF @ID = 0 BEGIN
    INSERT INTO ATHLETICS_CONTACTINFO (
        [Phone],
        [Email],
        [Address],
        [ContactName]
    )
    VALUES (
        @Phone,
        @Email,
        @Address,
        @ContactName
    )
set @ID = @@Identity;
END
ELSE BEGIN
    UPDATE ATHLETICS_CONTACTINFO SET 
        [Phone] = @Phone,
        [Email] = @Email,
        [Address] = @Address,
        [ContactName] = @ContactName
    WHERE [ID] = @ID

END

SET NOCOUNT OFF