Select the first 3 rows of each table in a database

sql sql-server-2008 select

Here you have:

DECLARE @sql VARCHAR(MAX)='';SELECT @sql=@sql+'SELECT TOP 3 * FROM '+'['+SCHEMA_NAME(schema_id)+'].['+name+']'+';'  FROM sys.tablesEXEC(@sql)

sql sql-server-2008 select

 exec sp_MSforeachtable 'select top 3 * from ?'

CodeHunter