{"id":1412,"date":"2004-05-18T14:44:42","date_gmt":"2004-05-18T14:44:42","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1412"},"modified":"2004-05-18T14:44:42","modified_gmt":"2004-05-18T14:44:42","slug":"%ed%8a%b9%ec%a0%95%eb%94%94%eb%b9%84%ec%9d%98-%eb%aa%a8%eb%93%a0-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%9d%98-row%ec%88%98-%ec%95%8c%ec%95%84%eb%82%b4%ea%b8%b0-2","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1412","title":{"rendered":"\ud2b9\uc815\ub514\ube44\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc758 row\uc218 \uc54c\uc544\ub0b4\uae30 2"},"content":{"rendered":"<p> \uc608\uc804\uc5d0 \ud504\ub85c\uc2dc\uc800\ub85c \ub9cc\ub4e4\uc5c8\uc5c8\ub294\ub370.<br \/>\n&#8211;><br \/>\nhttp:\/\/222.112.187.32:9090\/solui\/blueboard\/board\/solui_study\/content.asp?b_nm=solui_study&#038;s_num=61&#038;GotoPage=1&#038;order=<\/p>\n<p>\uadf8\ub0e5 sql\ubb38\ub3c4 \ud568 \ubcf4\uc790..<\/p>\n<p>set nocount on<br \/>\ndeclare @name varchar(80)<br \/>\nselect @name = &#8216;<\/p>\n<p>while @name is not null<br \/>\nbegin<br \/>\n  select @name = min(table_name) from information_schema.tables<br \/>\n  where table_type = &#8216;base table&#8217; and table_name > @name<\/p>\n<p>  if @name is not null<br \/>\n  begin<br \/>\n   select &#8216;\uac00\uc838\uc628 \ud14c\uc774\ube14 \uc774\ub984:&#8217;+ @name<br \/>\n   exec (&#8216;select count(*) from &#8216; + @name)<br \/>\n  end<br \/>\nend <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc608\uc804\uc5d0 \ud504\ub85c\uc2dc\uc800\ub85c \ub9cc\ub4e4\uc5c8\uc5c8\ub294\ub370. &#8211;> http:\/\/222.112.187.32:9090\/solui\/blueboard\/board\/solui_study\/content.asp?b_nm=solui_study&#038;s_num=61&#038;GotoPage=1&#038;order= \uadf8\ub0e5 sql\ubb38\ub3c4 \ud568 \ubcf4\uc790.. set nocount on declare @name varchar(80) select @name = &#8216; while @name is not null begin select @name = min(table_name) from information_schema.tables where table_type = &#8216;base table&#8217; and table_name > @name if @name is not null begin select &#8216;\uac00\uc838\uc628 \ud14c\uc774\ube14 \uc774\ub984:&#8217;+ @name exec (&#8216;select count(*) from &hellip; <a href=\"https:\/\/bluesoul.pe.kr\/wp\/?p=1412\" class=\"more-link\">\uacc4\uc18d \uc77d\uae30<span class=\"screen-reader-text\"> &#8220;\ud2b9\uc815\ub514\ube44\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc758 row\uc218 \uc54c\uc544\ub0b4\uae30 2&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1412","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1412"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1412\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}