Hello everybody...
I have a doubt, I have 4 tables in my database SQL 2008 R2.
I did a lot of test in my program, and I created more IDs in Table_1 than another tables.
My problem is that I make a search in Table_1 to discover the ID, and I search this registered information in Table_2 in the same ID.
I did a lot of deletes to make a simple test in my program, so the Table_1 there are 493 elements, and the Table_2 there are 397 elements.
Consequently the last ID in Table_1 is 493 and 397 in Table_2, and my search it is doesn't work.
How can I make some delete, exemple: DELETE FROM Table_1 WHERE ID = 30, and after that I will register a new line, with Visual Studio C# 2010, and I want to create the register ID = 30, but it is created the register ID = 31, its is jump the number 30.
How can I do to have the both tables with the same IDs?
Since now, I want to thanks.
...
Go to the complete details ...