Stored Procedures [dbo].[MssWebUpdateOrderContact]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inOrderIdint4
@inContactIdint4
@inContactvarchar(30)30
@inTitlevarchar(50)50
@inNamevarchar(100)100
@inEmailvarchar(120)120
@inImportedbit1
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebUpdateOrderContact]
    @inOrderId int,
    @inContactId int,
    @inContact varchar(30),
    @inTitle varchar(50),
    @inName varchar(100),
    @inEmail varchar(120),
    @inImported bit
as
begin
    set nocount on;
    update OrderContacts
    set Contact = @inContact,
        Title = @inTitle,
        Name = @inName,
        Email = @inEmail,
        ImportedFlag = @inImported
    where OrderContacts.OrderFID = @inOrderId and OrderContacts.OrderContactID = @inContactId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateOrderContact] TO [MssExec]
GO
Uses