常用SQLServer语句

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'