常用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,'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'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!