在查询中经常要对两个表进行连接,需要知道两个表有哪些公共字段。我的解决办法是
用存储过程显示两个表的公共字段
CREATE procedure ggzd @userbiao1 sysname,@userbiao2 sysname as
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+b.name+',' from sysobjects a,syscolumns b,sysobjects c,syscolumns d
where a.id=b.id and c.id=d.id and a.xtype='U' and c.xtype='U' and
a.name=@userbiao1 and c.name=@userbiao2 and b.name=d.name
print substring(@sql,1,len(@sql)-1)
GO
exec ggzd userbiao1,userbiao2