Stored Procedures [dbo].[MssWebUpdateSmsContactName]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inContactPrikeyint4
@inContactNamevarchar(128)128
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebUpdateSmsContactName]
    @inContactPrikey int ,
    @inContactName varchar(128)
as
begin
    set nocount on
    update SakariContact set ContactName = @inContactName where SakariContactID = @inContactPrikey
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateSmsContactName] TO [MssExec]
GO
Uses