on mssql: select top 100 * from yourtable order by newid()
J
jezemine
@jezemine
Posts
-
"displaying recs randomly in a table" -
How to determine what DB is used -
how to write query to find the database objects in databasescheck out the INFORMATION_SCHEMA views. they will give you all this data. in particular for tables in views: select * from INFORAMATION_SCHEMA.TABLES if you want a comprehensive data dictionary of your database, check out the link in my sig below.