vendredi 20 février 2015

How to generate script to retrieve schema and only top 100 records from each table from SQL Server 2005

How to generate script to retrieve schema and only top 100 records from each table from SQL Server 2005. I need to generate scripts for 15-16 databases and each database has more than 50-60 tables. Is it possible to generate script to retrieve schema only some data in SQL Server 2005? If yes, how can I do this? Any help appreciated.


Aucun commentaire:

Enregistrer un commentaire