The easiest way to convert rownum(oracle) to SQL SERVER 2005 is to use top(x).

You ll have something like :

Oracle:

select col1, col2, ....

from tableX

where

clauses

And rownum = 5

SQL SERVER 2005

select top(5)...

I'm not really sure but you can try to add the backslah caracter like this :

truncate table table1

truncate table table2

etc...