retrieve the next ID from PK Identity

[magmo]

Hi


If I use this code...

SELECT MAX(ID) AS CID FROM dbo.tbl_tablename

The ID is a Primary Key with Identity turned on

What I would like is to retrieve the next ID number instead of the number of rows.

How can I do that?


Regards

 

[JamesLean]

To get the next ID that will be inserted into a table you can use:

SELECT IDENT_CURRENT('table') + IDENT_INCR('table') AS nextid

--James