Retrieve new identity value BEFORE inserting record into sql

Question

Is is possible to get new values for Id (IDENTITY) before/while inserting data in a table on Button Submit - CODE level C#?

Abhay Shanker · Answer

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

Biswa Pujarini Mohapatra · Answer

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()

Jignesh Trivedi · Answer

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