Posts Tagged ‘identity’

Get the next value of identity column

We are as programmers it is used to make Primary Key for table as Identity. Now if we want to pre know the next value that will be assigned when inserting new row, We can achieve that by calling SQL Function “IDENT_CURRENT” that get the current Value for the Primary Identity Column. SELECT IDENT_CURRENT (‘dbo.TableName’) […]

More »