Hi all,
I have a test databsae, I would like on occasion to list all rows in the
whole database. Is there a quick and easy way of doing so.
Thanks
Robert
If you mean all rows from all tables in a database, you can
use the undocumented sp_MSforeachtable
exec sp_MSforeachtable 'select * from ?'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment