Just a small tip:
Say you want to run a query that returns the first @X results of some query, such that @X is a parameter.
The simple "SELECT TOP @X ..." statement doesn't work. I found this weird, because I know for a fact that SQL 2005 supports using a parameter in the TOP clause (as opposed to SQL 2000 where you had to use either dynamic queries or the SET ROWCOUNT statement).
Solution - surround the parameter with parenthesis as so:
"SELECT TOP (@X) ..."
Something to remember...
No comments:
Post a Comment