Access: select top n * from table ORDER BY RND (ID) 'ID Auto Number Field for Database
SQL Server: SELECT TOP N * from Table ORDER BY NewID ()
Go to Liu Jun's blockttp: //blog.9cbs.net/liujun999999/archive/2004/11/177657.aspx
