Hello All,
I've a table that has 3 Columns:
Column A : Type - Auto Number.
Column B : Type - String.
Column C : Type - String.
The Current Data in the table is as follows:
1, "USA","Florida"
2, "USA, "Michigan"
3, "USA", "New York"
If a add new Row, the Column A, being Auto Number, takes my Count to 4 i.e.
4, "USA", "Texas"
Suppose I've deleted Row 3 and Row 4. The table data is now:
1, "USA","Florida"
2, "USA, "Michigan"
If I try to add a new Row, the Column A, being Auto Number, takes my Count to 5 (instead of 3). Its OK as Auto Number, by default, will follow this numbering.
My question is: Is there a way to programmatically figure out that my row is going to get added at 5, before I actually insert a row and figure it out by myself using @@Identity?
Thanks.