仅此一个年华

摘要： --查询数据库中某个特定的字段所在的所以表（不包含视图）select a.[name] 表名 from sysobjects aleft join(select [id],count(*) b from syscolumns where [name]in('Id','SellerNick') group by [id] having count(*)>1) b on a.[id]=b.[id]where b.id is not null and a.type'V'--创建虚拟表，把值带给他declare @tb table(NewSelle 阅读全文