Guest User

Untitled

a guest
Dec 11th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. DECLARE @Count int, @Sort NVARCHAR(45), @Direction BIT, @Page INT, @PageSize INT
  2.  
  3. /* ---------------------------------------
  4. USE THE VARIABLES BELOW TO TEST
  5. CHANGE THEM TO SEE HOW THE RESULT
  6. SET CHANGES ...
  7. --------------------------------------- */
  8.  
  9. SET @Sort = 'FirstName'
  10. SET @Direction = 0 -- ASC = 1, DESC = 0 OR NULL
  11. SET @Page = 1
  12. SET @PageSize = 50
  13.  
  14. EXEC ContactsSelCollection @Page,@PageSize,@Sort,@Direction,@TotalCount = @Count OUTPUT
  15. SELECT @Count
Add Comment
Please, Sign In to add comment