spAddUpdate_ClientClassYears

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@name	nvarchar(10)	IN
@ClientsId	int	IN
@Guid	uniqueidentifier	IN

Definition

Copy



create procedure [dbo].spAddUpdate_ClientClassYears(
    @PKID        int OUTPUT,
    @name        nvarchar(10),
    @ClientsId     integer,
    @Guid         uniqueidentifier
)
as
    if (@PKID<=0) begin
        insert into ClientClassYears(Name, Guid, ClientsID )
        values ( @name, @Guid, @ClientsId )
        select @PKID = @@Identity
    end else begin
        update dbo.ClientClassYears
        set Name = @name
           where ID=@PKID
    end