查看两表是否一样的存储过程

查看表数据是否一致
create procedure cccc
@name nvarchar(50)
as
begin
    declare @startRow nvarchar(max),@tems nvarchar(max)
    set @startRow = @name
    set @tems='SELECT SUM(CHECKSUM(*)) AS checksumvalue FROM ';
  
    exec(@tems+@startRow)
end
exec cccc books_new

查看差异数据
create procedure ccccc
@name nvarchar(50),
@name2 nvarchar(50)
as
begin
    declare @startRow nvarchar(max),@startRow2 nvarchar(max),@tems nvarchar(max),@tems2 nvarchar(max)
    set @startRow = @name
	set @startRow2 = @name2
	set @tems='select * from  ';
    set @tems2='select * from  ';
    exec  (@tems+@startRow  +  ' except ' + @tems2+@startRow2)
end
ccccc books,books_new
select * from books except select * from books_new
drop procedure  ccccc ;