kuldip.bhatt (1/20/2009)
That's right but thenwhat is the use of the set indentity ?
if we set it to max no value in the table.
so there no change in the table after or before this command.
are you referring to SET IDENTITY_INSERT ON? This is used to explicitly insert a specific value in the identity column.
Also what are you reffering to max value in the table? The max value is determined by the capacity of underlying datatype used for the identity column. If you use bigint instead of int, you can have more number of identity values.