Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Count int, @Sort NVARCHAR(45), @Direction BIT, @Page INT, @PageSize INT
- /* ---------------------------------------
- USE THE VARIABLES BELOW TO TEST
- CHANGE THEM TO SEE HOW THE RESULT
- SET CHANGES ...
- --------------------------------------- */
- SET @Sort = 'FirstName'
- SET @Direction = 0 -- ASC = 1, DESC = 0 OR NULL
- SET @Page = 1
- SET @PageSize = 50
- EXEC ContactsSelCollection @Page,@PageSize,@Sort,@Direction,@TotalCount = @Count OUTPUT
- SELECT @Count
Add Comment
Please, Sign In to add comment