LIMIT in query

[adrian_quah]

I know that the following statement

SELECT * FROM customer_support WHERE 1 LIMIT 0, 30

works in MySQL...Can anyone tell me if it's okay with MS SQL...because of the LIMIT 0,30 part.

thanks😃

Adrian

[IceD]

Should work as well 😉

[Lars_Berg]

Limit is not supported in MSSQL.

You can either use top or set rowcount.