예전에 프로시저로 만들었었는데.
–>
http://222.112.187.32:9090/solui/blueboard/board/solui_study/content.asp?b_nm=solui_study&s_num=61&GotoPage=1&order=
그냥 sql문도 함 보자..
set nocount on
declare @name varchar(80)
select @name = ‘
while @name is not null
begin
select @name = min(table_name) from information_schema.tables
where table_type = ‘base table’ and table_name > @name
if @name is not null
begin
select ‘가져온 테이블 이름:’+ @name
exec (‘select count(*) from ‘ + @name)
end
end
Comments
Powered by Facebook Comments