3.1.5.139 TVF_UserData_ListItemLevelRow

  • Article

The TVF_UserData_ListItemLevelRow table value function is invoked to return a subset of rows from the UserData view (section 2.2.7.8).

 FUNCTION [dbo].[TVF_UserData_ListItemLevelRow]
             (
                 @tp_ListId uniqueidentifier,
                 @tp_Id int,
                 @tp_Level tinyint,
                 @tp_RowOrdinal tinyint
             )

@tp_ListId: All the rows returned from the UserData view MUST have tp_ListId = @tp_ListId.

@tp_Id: All the rows return from the UserData view MUST have tp_Id = @ tp_Id.

@tp_Level: All the rows return from the UserData view MUST have tp_Level = @tp_Level.

@tp_RowOrdinal: All the rows returned from the UserData view MUST have tp_RowOrdinal = @tp_RowOrdinal.

Return Values: TVF_UserData_ListItemLevelRow returns all rows from the UserData view that are specified as follows.

  
  (tp_ListId = @tp_ListId AND tp_Id = @tp_Id  AND tp_Level = @tp_Level AND  tp_RowOrdinal = @tp_RowOrdinal)