spAddUpdate_Domain

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@Domain	nvarchar(256)	IN
@ReCaptchaPublicKey	nvarchar(40)	IN
@RecaptchaPrivateKey	nvarchar(40)	IN

Definition

Copy



            create procedure dbo.spAddUpdate_Domain
            (
                @ID int output,
                @Domain nvarchar(256),
                @ReCaptchaPublicKey nvarchar(40),
                @RecaptchaPrivateKey nvarchar(40)
            ) as
                if (@ID <= 0) begin
                    insert into dbo.Domains (
                        Domain,
                        ReCaptchaPublicKey,
                        RecaptchaPrivateKey
                    ) values (
                        @Domain,
                        @ReCaptchaPublicKey,
                        @RecaptchaPrivateKey
                    );
                    set @ID = @@Identity;
                end else begin
                    update dbo.Domains set
                        Domain = @Domain,
                        ReCaptchaPublicKey = @ReCaptchaPublicKey,
                        RecaptchaPrivateKey = @RecaptchaPrivateKey
                    where
                        ID = @ID;
                end;