[MSSQL] ident 數值查詢

查詢目前識別值

select o.name, c.name , c.type , IDENT_CURRENT(o.name) 目前的識別值, IDENT_INCR(o.name) 遞增值
from syscolumns c inner join sysobjects o on c.id=o.id   
where c.status & 0x80 = 0x80 and o.type='U'

Refer: http://diary.tw/tim/search/identity