Sample Contacts Testing Script

ContactsTest.sql

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