34,576
社区成员
发帖
与我相关
我的任务
分享
-- 轻骑兵的
SELECT SS.name+'.'+SO.name
FROM sys.objects SO
INNER JOIN sys.schemas SS ON SO.schema_id = SS.schema_id
INNER JOIN sys.columns SC ON SO.object_id = SC.object_id
WHERE SO.type ='U' AND SC.name in ( 'username' ,'user_name')
order by a.name
-- 国哥的
select a.[name],b.[name]
from sys.schemas as a join sys.objects as b
on a.schema_id=b.schema_id
where b.type='u' and b.object_id in (SELECT id FROM [syscolumns] WHERE [name]='username' OR [name]='user_name'
)
order by a.name
select a.[name],b.[name]
from sys.schemas as a join sys.objects as b
on a.schema_id=b.schema_id
and object_id in (SELECT id FROM [syscolumns] WHERE [name]='username' OR [name]='user_name'
)
SELECT SS.name+'.'+SO.name
FROM sys.objects SO
INNER JOIN sys.schemas SS ON SO.schema_id = SS.schema_id
INNER JOIN sys.columns SC ON SO.object_id = SC.object_id
WHERE SO.type ='U' AND SC.name in ( 'username' ,'user_name')
SELECT SS.name,SO.name
FROM sys.objects SO
INNER JOIN sys.schemas SS ON SO.schema_id = SS.schema_id
INNER JOIN sys.columns SC ON SO.object_id = SC.object_id
WHERE SO.type ='U' AND SC.name = 'username'
select [name] from sysobjects where xtype ='u' and
id in
(select id from syscolumns where [name]='username' or [name]='user_name')
SELECT [name] FROM [sysobjects] WHERE [id] in(
SELECT id FROM [syscolumns] WHERE [name]='username' OR [name]='user_name'
)
/*这样完全OK,2000 OR 2005都执行正常,无误。*/
use MY_DB
go
----2005写法
select [name] from sysobjects where xtype ='u' and id in(
select id from syscolumns where [name]='username' or [name]='user_name')
--2000写法,好像是有一个字段名字不一样
select [name] from sysobjects where type ='u' and id in(
select id from syscolumns where [name]='username' or [name]='user_name')
select [name] from sysobjects where xtype ='u' and id in(
select id from syscolumns where [name]='username' or [name]='user_name')