sql 两表同名字段大小对比

declare @biao1 varchar(400)
declare @biao2 varchar(400)
select @biao1= 'table1'    --输入相应的表
select @biao2= 'table2' --输入相应的表

SELECT a.COLUMN_NAME, a.DATA_TYPE,b.TABLE_NAME,b.CHARACTER_MAXIMUM_LENGTH length,a.TABLE_NAME, a.CHARACTER_MAXIMUM_LENGTH length
FROM INFORMATION_SCHEMA.COLUMNS a,(SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME =  @biao1 and data_type='varchar') b
WHERE a.TABLE_NAME =  @biao2 and a.data_type='varchar' and a.column_name=b.column_name and a.CHARACTER_MAXIMUM_LENGTH<>b.CHARACTER_MAXIMUM_LENGTH
ORDER BY a.column_name