missing serial number in table

[GokulGKM]

hi,

      i have sql table with serial number coloum example

S:no            name              ID

1                  ravi                 123

2                 sham               528

3                 swan               586 

every time i add new data  increament one serial number manually.than i delete serial numger 2.next i add new add serial number 4 now.but i want insert the new data at serial number 2.because my serial number data type is 'int' so maximum 65,485 only.

when i insert the new data 1first check missing serial number(2).if have new data insert serial number 2.else insert serial max(4).how can i check missing serial number because i have 10,000 of data in table.

have any sql  query check the missing serial number.

[Bob_Schor]

You do know this is a LabVIEW Forum, don't you?  I think you've been here enough to know that we help with specific LabVIEW questions/problems, usually accompanied by a VI that you have written and attached to the post.  This is not the place to ramble about Sql.

Bob Schor