Monday, July 26, 2010

Implementing the OUTPUT Clause in SQL Server 2008

Wednesday, July 07, 2010

Batch File Commands

From the old days, sometimes batch file becomes very handy

Tuesday, July 06, 2010


create table #rowcount (tablename varchar(128), rowcnt int)
exec sp_MSforeachtable 'insert into #rowcount select ''?'', count(*) from ?'
select top 5 * from #rowcount order by rowcnt desc
select * from #rowcount
drop table #rowcount