SQL返回值放到新的变量之中

alter procedure discrepant1 emp,emp_new
@tablename varchar(50),
@tablename2 varchar(50)
as
begin
		declare 
		@SQL nvarchar(4000),
		@Table1Count int,
		@Table2Count int
		set    @SQL='select count(1) from ' 
		set    @SQL='select @Table1Count =  count(1) from '  + @tablename
		EXEC sp_executesql @SQL, N'@Table1Count int out', @Table1Count OUT		
		set    @SQL='select @Table2Count =  count(1) from ' + @tablename2
		EXEC sp_executesql @SQL, N'@Table2Count int out', @Table2Count OUT
                ————EXEC sp_executesql将SQL返回值放入新的变量之中
		
		if @Table1Count = @Table2Count
			begin 
			print @Table1Count
			print @Table2Count
				  print '两表数据量相同'
			  end 
			else 
		  begin 
			  print '两表数据量不同'
		  end   
end