Limit in mysql = top in sql server ?

I have used this mysql code in my programm before:

select * from address order by vorname asc limit 0, 10

It works fine. But now I want to use sql server, and it doesn't recognize the term limit.
So I have found out that I can use top instead.
I have changed my code into this:

select top 0 * from (select top 10* from address order by vorname) order by vorname asc

But it gives me an error message:

wrong syntax near the word Order.

Can anyone give me a solution?
Thank you.

Why complicate matters?

Sorry, my mistake
it works fine if the limit is 0,10
but what if the limit is 10,10 ?

Thank you

I'm afraid this won't really help.

look at this example :

id |val
---+---
1 | aa
2 | aa
3 | bb
4 | bb

"SELECT * ORDER BY val ASC"

will return

1,aa
2,aa
3,bb
4,bb

"SELECT * ORDER BY val DESC"

will return

3,bb
4,bb
1,aa
2,aa

Vou see, this isn't what we would expect under MySQL.
MSSQL doesn't actually reverse the recordset with your approach.

What recordset? There is no order to reverse. If you order by a column which have duplicates you can't predict anything about the order within the group.

To get the order

id val
-----
4 bb
3 bb
2 aa
1 aa

you must use