WinUtilis
__

TS SQL Notes

/* Create a count query for all the tables on the db */ SELECT 'select count(*) ''Count' +''', ''' +TABLE_SCHEMA +'.' +TABLE_NAME +''' [Name] from ' +TABLE_SCHEMA +'.[' +TABLE_NAME +'] union' FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME -- Always delete the last union on the last row.> ------------------------------------------------------------------------------ /* Create a select 5 rows query for all the tables on the db */ SELECT 'select top 5 '''+TABLE_NAME +''' [Colum Name],* from ' +TABLE_SCHEMA +'.[' +TABLE_NAME +']' FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME ------------------------------------------------------------------------------
 
© 2006 Javier Hernandez. All rights reserved. Terms of Use