declare @s varchar(8000) set @s = ''select @s = ',a.'+name from syscolumns where id = object_id('a') and name != 'name'select @s = ',b.'+name from syscolumns where id = object_id('b') and name not in(select name from syscolumns where id = object_id('a'))set @s = 'create view ab_view as select a.name'+@s+' from a,b where a.name=b.name'exec(@s)
declare @s varchar(8000)
set @s = ''select
@s = ',a.'+name
from
syscolumns
where
id = object_id('a')
and
name != 'name'select
@s = ',b.'+name
from
syscolumns
where
id = object_id('b')
and
name not in(select name from syscolumns where id = object_id('a'))set @s = 'create view ab_view as select a.name'+@s+' from a,b where a.name=b.name'exec(@s)
对象浏览器中所有的目录都可以拖到右边的SQL文本编辑器中,楼主可以拖动需要的Table下的"Columns"这个目录,看看有什么效果.如果想在所有栏位前面加上Table的前缀名,最好是用EditPlus什么的文本编辑器,将逗号替换成table名+逗号就ok了.