Stored Procedures [dbo].[MssWebUpdateSakariContactLastReadAt]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inContactIdint4
@inSysUserIdint4
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebUpdateSakariContactLastReadAt]
    @inContactId int ,
    @inSysUserId int
AS
BEGIN
    update SakariContactSysUserMap set LastReadAt = GetDate()
    where SakariContactFID = @inContactId and
    SysUserFID = @inSysUserId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateSakariContactLastReadAt] TO [MssExec]
GO
Uses