Compare Row Count in vs 2012

See more:

C#

SQL-Server

C#4.0

Hi,
I am Write Unit Test Cases for Stopred Procedure in vs 2012.In Test case execute stored procedure and get the row count.also the Get the row count in other table.I am try to compare both rowcounts.i am write script that script work on sql server but 2012 row count compare the table value.Plese help me to solve this problem.

This is code

/*TagHistory Export Test. Testing with default paramaeters*/


SET NOCOUNT ON;
DECLARE @TagHistoryRowCount int=0;
DECLARE @ExportProcRowCount int=0;

--Executing aaInternalTagHistoryExport procedure
EXEC aaInternalTagHistoryExport;

SELECT @ExportProcRowCount=@@ROWCOUNT;

SELECT @TagHistoryRowCount=COUNT(*) 
FROM dbo.TagHistory

IF(@ExportProcRowCount = @TagHistoryRowCount)
 SELECT 1;
ELSE
 SELECT 0;

Error : ScalarValueCondition Failed: ResultSet 1 Row 1 Column 1:Values do not match,actual'R5Obj219' expected '1'.