How to "select" the current identifier value for a table?

Question

dbcc checkident (MyTable, NORESEED)

Will show the identification value in the message. I do not see the message, because I need to select the identifier value through the DataReader .

Any ideas?

Thanks guys

Answer 1

 SELECT IDENT_CURRENT('MyTable') 

See BOL

Answer 2

 SELECT IDENT_CURRENT('TABLE_NAME') 

returns NULL if no identifier is specified in the table

Answer 3

  select @@identity 

can work,

also exists

 SELECT SCOPE_IDENTITY()