SQL Help

Would this be correct?

strSQL = "SELECT TOP 10 * FROM products WHERE 1=1 ORDER BY pDateAdded DESC"



Is there anther way to write it?

http://www.databasejournal.com/features/mssql/article.php/3532226 may help!