sql server查看两个表字段类型不同

ALTER  proc   [dbo].[usp_proc_getcolumdiffrent](@table1   varchar(50),@table2   varchar(50))  
as
select * into #fb from syscolumns  where id =(select max(id) from sysobjects where xtype='U' and name=@table1)

select * into #bz from syscolumns  where  id =(select max(id) from sysobjects where xtype='U' and name=@table2)

create  table #colunm
(name1   varchar(64),length1 varchar(10),name2   varchar(64),length2 varchar(10))   

insert into #colunm
select a.name,a.length,b.name,b.length from #fb a,#bz b where a.name = b.name 
and a.length <> b.length

select * from #colunm
drop table #fb
drop table #bz