How to 'select' the current identity value for a table?

dbcc checki开发者_如何学Godent (MyTable, NORESEED)

Will show the identity value in a message. I can't see the message as I need to select the identity value through a DataReader.

Anyone any ideas?

Thanks folks

---

SELECT IDENT_CURRENT('MyTable')

See BOL

---

SELECT IDENT_CURRENT('TABLE_NAME')

returns NULL if there is no identity defined in the table

---

 select @@identity

might work,

there is also

SELECT SCOPE_IDENTITY()