USP_DEVSPACESETTINGS_CREATEORUPDATE

Creates or updates the settings in the DEVSPACESETTINGS table

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@ALLOWCLR	bit	IN
@ALLOWUNSIGNED	bit	IN

Definition

Copy




CREATE procedure dbo.USP_DEVSPACESETTINGS_CREATEORUPDATE (
    @CHANGEAGENTID uniqueidentifier = null,
    @ALLOWCLR bit,
    @ALLOWUNSIGNED bit
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE as datetime;
    set @CURRENTDATE = GetDate();

    begin try
        if exists(select top 1 ID from dbo.DEVSPACESETTINGS) 
            -- handle updating the data

            update dbo.DEVSPACESETTINGS set
                ALLOWCLR = @ALLOWCLR,
                ALLOWUNSIGNED = @ALLOWUNSIGNED,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE 
        else
            insert into dbo.DEVSPACESETTINGS (ID, ALLOWCLR, ALLOWUNSIGNED, ADDEDBYID, DATEADDED, CHANGEDBYID, DATECHANGED)
                values (newid(), @ALLOWCLR, @ALLOWUNSIGNED, @CHANGEAGENTID, @CURRENTDATE , @CHANGEAGENTID, @CURRENTDATE ) 

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch