General discussion
December 21, 2004 at 01:37 AM
micdev42

Why would you use SELECT TOP 100 PERCENT in a SQL Server 2000 query?

by micdev42 . Updated 20 years, 2 months ago

Sorry if this is a bit basic, but I’ve just seen Arthur Fuller’s ‘Alter every table in a database’ email article which I’ve just been sent via SQL Server Tips at Builder.com.
He uses the above idiom to return table names. What not just use SELECT x from table? Am I missing something?

BTW, I would have asked him the question directly but, by searching builder.com…
1. I can’t find this article online.
2. I can’t find a reference to Arthur.

Answers to any of the above would be appreciated. Thanks.
Michael

This discussion is locked

All Comments