A. No - row numbering is contrary to relational sets (which is what rdbms's running SQL are all about). It is not an ANSI standard. Microsoft have not implemented anything like it.
If you need to use row numbers you should look at your application and see if it is really appropriate to a SQL database.