Retrieve new identity value BEFORE inserting record into sql

In Sql Server Id (Identity column) is generated itself when a record is inserted into table.Still you want the id valuewhen inserting a record then get the max id from the table

Select Max(Id) from table.

In coding part you need to add 1 or what ever condition you have defined in identity column

You can get the last inserted id by using
select max(id) from customer.

also you can get the new id after insertion using
select scope_identity()

hi,

I think this is not possible because SQL server generate Id for Identity column at the time of inserting the record.