1:某表的某个字段是否存在
select count(1) from syscolumns where [id]=object_id('dt_article') and [name]='call_index'
2:某表某字段里的最小值
select min(id) from dt_article
3:获取某表某字段里的最大值,并且加1
select max(id)+1 from dt_article
4:表是否存在
select count(*) from sysobjects where id = object_id(N'[dt_article]') and OBJECTPROPERTY(id, N'IsUserTable') = 1
SELECT count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dt_article]') AND type in (N'U')
5:获取表或试图
Select o.id,o.Name As ObjectsName, 'Table' as Type From SysObjects As o Where o.type in ('u') union all Select o.id,o.Name As ObjectsName,'View' as Type From SysObjects As o Where o.type in ('v')
6:根据表名或者试图名称获取对应的字段名称
select a.name from sys.columns a left join sys.types b on a.user_type_id=b.user_type_id where a.object_id=object_id('dt_article')
7:根据表名或者试图名称和字段名获取对应的数据类型
select a.name,(b.name+'('+cast(a.max_length as varchar(100)))+')' as type from sys.columns a left join sys.types b on a.user_type_id=b.user_type_id where a.object_id=object_id('dt_article') and a.name='id'