Stored Procedures [dbo].[MssWebUpdateOrderTasks]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inToDoIdsIntListmax
@inChangedBySysuserIdint4
@inNewDueDatedatetime8
@inNewSysuserIdint4
@inNewNotevarchar(max)max
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebUpdateOrderTasks]
    @inToDoIds IntList readonly,
    @inChangedBySysuserId int,
    @inNewDueDate datetime,
    @inNewSysuserId int,
    @inNewNote varchar(max)
as
begin
    set nocount on

    exec [dbo].[UpdateTasks]
        @inToDoIds = @inToDoIds,
        @inChangedBySysuserID = @inChangedBySysuserID,
        @inNewDueDate = @inNewDueDate,
        @inNewSysuserID = @inNewSysuserID,
        @inNewNote = @inNewNote
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateOrderTasks] TO [MssExec]
GO
Uses