Store the code below as a bat file, can obtain the number of rows in all the tables and views.--
--
@echo off
set db=Northwind
FOR /F "skip=2" %%G IN ('sqlcmd -E -S localhost -d %db% -Q "set nocount
on; set ansi_warnings off; select TABLE_NAME from
INFORMATION_SCHEMA.TABLES order by table_name;"') DO (
REM echo dump table %%G ..
FOR /F "skip=2" %%X IN ('sqlcmd -E -S localhost -d %db% -Q "set nocount
on; set ansi_nulls on; set ansi_warnings on; select count(*) from
%%G;" -s "," -W') DO (
echo [%%G]: %%X
)
)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment