[dbo].[MssWebUpdateSmsContactName]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUpdateSmsContactName

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inContactPrikey	int	4
@inContactName	varchar(128)	128

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

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

[dbo].[SakariContact]
dbo