Quick Tip: MS SQL TOP = MySQL Limit

 The MS SQL equivalent of MySQL’s LIMIT clause is TOP. Example:
SELECT TOP 10 * FROM stuff;
Will return the top ten rows, effectively doing the same thing as
SELECT * FROM stuff LIMIT 10;