Stored Procedures [dbo].[MssWebInsertUpdateUserSignature]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inSysUserIdint4
@inSignaturevarchar(256)256
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebInsertUpdateUserSignature]
    @inSysUserId int,
    @inSignature varchar(256)
as
begin
        merge SakariUserSignature with(tablock) as target
            using (select @inSysuserID, @inSignature) as source (SysuserFID, SignatureValue)
        on( target.SysUserFID = source.SysuserFID )
            when matched then
                update set Signature = source.SignatureValue
            when not matched then
                insert( SysuserFID, Signature ) values( source.SysuserFID, source.SignatureValue );
end
GO
GRANT EXECUTE ON  [dbo].[MssWebInsertUpdateUserSignature] TO [MssExec]
GO
Uses