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