Yes
It must be somthing like a timestamp or a auto increasing value that keeps rising, so db connect has a flag that identifies until which point the data has been indexed, and from that point index the new data every time the sql query is executed.
Regards
they dont have that , also rows are not increasing , it will just find the name and update it , they also dont have lastupdate column
Do they give you an Identity field such as "ID"?, i believe it needs to be in that table or a combination of fields that are equivalent to a number or date that would be unique per record.
the problem is the db dont have rising_column,the customer just gave a query to use SELECT GETDATE() AS Server_Time ,name from information,the server_time will be the rising_column,everytime i run the query all the server_time column is the same, but if you run it again it will give you a different time, ex.i run it 6:36pm all the 1000rows server_time result will be 6:36pm,does the rising column needs to be in the database??