找到所有字段名为'aa'的表名 select b.[name] from syscolumns a, sysobjects b where a.[name] = 'aa' and b.[id] = a.[id] 如果要在ta tb中判断,加上 select b.[name] from syscolumns a, sysobjects b where a.[name] = 'aa' and b.[id] = a.[id] and (b.[name] = 'ta' or b.[name] = 'tb')
select b.[name] from syscolumns a, sysobjects b where a.[name] = 'aa' and b.[id] = a.[id]
如果要在ta tb中判断,加上
select b.[name] from syscolumns a, sysobjects b where a.[name] = 'aa' and b.[id] = a.[id] and (b.[name] = 'ta' or b.[name] = 'tb')
问一下
为何
select [value] from ::fn_listextendedproperty(NULL, N'user', N'dbo', N'table', N'T_S_QueryContent', N'column', N'FieldName')
这个语句在查询分析器中可以执行出结果
把它加到ADOQUERY的SQL中后,双击ACTIVE老提示
"fn_listextendedproperty"附近有语法错误????
1 直接用:的asc码加入
2 用另外一种方法,在sysproperties系统表中直接select
是什么意思?
求教!
from sysobjects
where id in (select id from syscolumns where name='your name')