[dbo].[MssWebInsertUpdateUserSignature]
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