Why does SQL2008 only show 1000 before opening a hotel? How can I show all this?

Don't you have the words top 1000 in front of you?

If there is, you should remove it, but it will take up a lot of temporary space on disk C.

you can

Select * from table name, where id > = 1 and id < =1000.

then

Select * from table name, where id > = 100 1, id < = 2000.