{"id":1444,"date":"2005-10-11T11:58:27","date_gmt":"2005-10-11T11:58:27","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1444"},"modified":"2005-10-11T11:58:27","modified_gmt":"2005-10-11T11:58:27","slug":"%ed%8a%b9%ec%a0%95%ed%85%8c%ec%9d%b4%eb%b8%94%ec%9d%98-row%ec%88%98-%ec%82%ac%ec%9d%b4%ec%a6%88%eb%93%b1%ec%9d%84-%ec%95%8c%ea%b3%a0-%ec%8b%b6%ec%9d%84%eb%95%8c-%ec%93%b0%eb%8a%94-%ed%94%84%eb%a1%9c","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1444","title":{"rendered":"\ud2b9\uc815\ud14c\uc774\ube14\uc758 row\uc218, \uc0ac\uc774\uc988\ub4f1\uc744 \uc54c\uace0 \uc2f6\uc744\ub54c \uc4f0\ub294 \ud504\ub85c\uc2dc\uc838"},"content":{"rendered":"

– \ud2b9\uc815 \ud14c\uc774\ube14\ub9cc \uc54c\uace0 \uc2f6\uc744\ub54c
\nEXEC sp_spaceused ‘\ud14c\uc774\ube14\uba85’;<\/p>\n

– \ud2b9\uc815\ub514\ube44\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \uc54c\uace0 \uc2f6\uc744\ub54c
\nuse mousebbs
\ngo
\nexec sp_MSforeachtable “exec sp_spaceused ‘?'”<\/p>\n

– \uc870\uac74\uc5d0 \ub530\ub978
\nuse mouseBBS
\ngo
\ndeclare @tblName varchar(30)
\ndeclare curGetTableName INSENSITIVE CURSOR<\/p>\n

for
\n\tselect tableName from tableinfo where groupcode=2
\nfor read only<\/p>\n

open curGetTableName<\/p>\n

fetch from curGetTableName into @tblname<\/p>\n

while @@FETCH_STATUS = 0
\nbegin
\n\texec sp_spaceused @tblName
\n\tFETCH FROM curGetTableName INTO @tblName
\nend<\/p>\n

close curGetTableName
\ndeallocate curGetTableName
\ngo <\/p>\n","protected":false},"excerpt":{"rendered":"

– \ud2b9\uc815 \ud14c\uc774\ube14\ub9cc \uc54c\uace0 \uc2f6\uc744\ub54c EXEC sp_spaceused ‘\ud14c\uc774\ube14\uba85’; – \ud2b9\uc815\ub514\ube44\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c \uc54c\uace0 \uc2f6\uc744\ub54c use mousebbs go exec sp_MSforeachtable “exec sp_spaceused ‘?’” – \uc870\uac74\uc5d0 \ub530\ub978 use mouseBBS go declare @tblName varchar(30) declare curGetTableName INSENSITIVE CURSOR for select tableName from tableinfo where groupcode=2 for read only open curGetTableName fetch from curGetTableName into @tblname while @@FETCH_STATUS … \uacc4\uc18d \uc77d\uae30 “\ud2b9\uc815\ud14c\uc774\ube14\uc758 row\uc218, \uc0ac\uc774\uc988\ub4f1\uc744 \uc54c\uace0 \uc2f6\uc744\ub54c \uc4f0\ub294 \ud504\ub85c\uc2dc\uc838”<\/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-1444","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\/1444","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=1444"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1444\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}