DECLARE @SQLString nvarchar(500);
DECLARE @Count int;
SET @SQLString = N'SELECT @CountOUT = Count(1)
FROM M_Location WHERE SeqID =' + cast (1 as varchar(20));

EXECUTE sp_executesql @SQLString, N'@CountOUT int OUTPUT', @CountOUT = @Count OUTPUT;
SELECT @Count;