Request for a technical term

I'm not really sure how to explain this, so please bear with me.

I have a SQL statement, such as:

SELECT TOP (10) FROM chartTracks

This works with SQL Server Express 2005, but when I moved my site over to work with a MSSQL Server 2000, the statement had to be changed in order for it to work:

SELECT TOP 10 FROM chartTracks

I was just wondering if there was a technical term for this, and if possible, the locations of anymore sourecs of information regarding the above?

I'm just writing a report and would like to include this, if possible.
Thanks in advance!

Did you miss something in the statement? Column name should follow the 'top N', as:

SELECT TOP (10) * FROM chartTracks

This is just a T-SQL syntax issue. It proves that in SQL2005 the T-SQL is more flexible.

|||

Oops, yes I did. Thank you!

T-SQL? Is that what it's all about? I'll look that up, thanks again.