create procedure [dbo].[MssWebInsertOrderContact]
    @inOrderId int,
    @inContact varchar(30),
    @inTitle varchar(50),
    @inName varchar(100),
    @inEmail varchar(120),
    @inImported bit
as
begin
    set nocount on;
    insert into OrderContacts(
        OrderFID,
        Contact,
        Title,
        Name,
        Email,
        ImportedFlag)
    select OrderFID = @inOrderId,
        Contact = @inContact,
        Title = @inTitle,
        Name = @inName,
        Email = @inEmail,
        ImportedFlag = @inImported;

    declare @id int = SCOPE_IDENTITY();
    select @id
end
GO
GRANT EXECUTE ON  [dbo].[MssWebInsertOrderContact] TO [MssExec]
GO