1）select top 100 * from <table_name> order by newid()
NEWID()函数，用于创建uniqueidentifier 类型的唯一值。详见SQL Server 2000联机丛书2）select top 100 * from <table_name> order by rand()
