Sql query for SELECT all the records or rows of all tables in database in sql server

Sql query for SELECT all the records or rows of all tables in database in sql server

We can select all the records or rows of all tables of sql of given database using system stored procedure sp_MSforeachtable. For example:

EXECUTE sp_MSforeachtable N'SELECT * FROM ?'

If you have any quires you can ask here.