hello guys, i'm creating a SQL table in SQL Server 2008 Express R2.
I created a column name "Index_Num", and I set it to Primary Key and Auto Increment.
My question is, if I have let's say 100 rows.
And if ever, I will move the very firs row (row number 1).
Will SQL allow it?
And the system will auto renumber the column?
Please advise, or what would be the other good practice?
Thanks. :)
Every second counts..make use of it. Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
IT Stuff Quick Bytes
Go to the complete details ...