When performing a First-style query and top is specified, you should use top 1; additional rows will be silently ignored, so they’re
just wasting bandwidth.
Bad:
select top 10 Id, Name
from Users
Good:
select top 1 Id, Name
from Users
When performing a First-style query and top is specified, you should use top 1; additional rows will be silently ignored, so they’re
just wasting bandwidth.
Bad:
select top 10 Id, Name
from Users
Good:
select top 1 Id, Name
from Users