Hello. Android!!

SET NOCOUNT ON

CREATE TABLE #TBLSize 

( 

Tblname varchar(80), 

TblRows int, 

TblReserved varchar(80), 

TblData varchar(80), 

TblIndex_Size varchar(80), 

TblUnused varchar(80) 

)

DECLARE @DBname varchar(80) 

DECLARE @tablename varchar(80)

SELECT @DBname = DB_NAME(DB_ID()) 

PRINT 'User Table size Report for (Server / Database): ' + @@ServerName + ' / ' + @DBName

PRINT '' 

PRINT 'By Size Descending'

DECLARE TblName_cursor CURSOR FOR 

SELECT NAME 

FROM sysobjects 

WHERE xType = 'U'

OPEN TblName_cursor

FETCH NEXT FROM TblName_cursor 

INTO @tablename

WHILE @@FETCH_STATUS = 0 

BEGIN 

INSERT INTO #tblSize(Tblname, TblRows, TblReserved, TblData, TblIndex_Size, TblUnused) 

EXEC Sp_SpaceUsed @tablename

-- Get the next author. 

FETCH NEXT FROM TblName_cursor 

INTO @tablename 

END

CLOSE TblName_cursor 

DEALLOCATE TblName_cursor

SELECT CAST(Tblname as Varchar(30)) 'Table', 

CAST(TblRows as Varchar(14)) 'Row Count', 

CAST(LEFT(TblReserved, CHARINDEX(' KB', TblReserved)) as int) 'Total Space (KB)', 

CAST(TblData as Varchar(14)) 'Data Space', 

CAST(TblIndex_Size as Varchar(14)) 'Index Space', 

CAST(TblUnused as Varchar(14)) 'Unused Space' 

FROM #tblSize 

Order by 'Total Space (KB)' Desc

PRINT '' 

PRINT 'By Table Name Alphabetical'

SELECT CAST(Tblname as Varchar(30)) 'Table', 

CAST(TblRows as Varchar(14)) 'Row Count', 

CAST(LEFT(TblReserved, CHARINDEX(' KB', TblReserved)) as int) 'Total Space (KB)', 

CAST(TblData as Varchar(14)) 'Data Space', 

CAST(TblIndex_Size as Varchar(14)) 'Index Space', 

CAST(TblUnused as Varchar(14)) 'Unused Space' 

FROM #tblSize 

Order by 'Table'

DROP TABLE #TblSize

SET NOCOUNT OFF

declare cur cursor for  -- 커서선언

 select a.sayear, a.entsubno, d.saitmcd

   from TEST a

        -- 조회쿼리 

open cur

        -- 조회쿼리 항목들을 변수로 선언 (갯수가 동일해야 한다 )

 declare @year char(4)

  ,@entsubno char(6)

  ,@saitmcd char(11)

 fetch next from cur into @year, @entsubno, @saitmcd

 while @@fetch_status = 0

 begin 

  insert into TEST_subitm ( sayear, entsubno, saitmcd)

  values (@year,@entsubno,@saitmcd)

                --실행쿼리부분

 fetch next from cur into @year, @entsubno, @saitmcd

 end

close cur

deallocate cur

---------------------------------------------------

전체적인순서

1. 쿼리로 커서선언

2. 커서 OPEN

3. 데이터 선언

4. 첫번째 레코드의 값을 변수에 셋팅

5. 패치상태가 정상이면 while 반복문 실행

6. 반복문 시작 

7. 실행쿼리 실행

8. 다음 레코드의 값을 변수에 셋팅

9. 반복문 종료

10. 커서 CLOSE

11. 커서메모리 반환

<style> 
.rtop, .rbottom{display:block;} 
.rtop *, .rbottom *{display:block; height:1px; overflow:hidden;} 
.r1{margin:0 5px; background:#CCCCCC} 
.r2{margin:0 3px; border-left:2px solid #CCCCCC; border-right:2px solid #CCCCCC;} 
.r3{margin:0 2px; border-left:1px solid #CCCCCC; border-right:1px solid #CCCCCC;} 
.r4{margin:0 1px; height:2px; border-left:1px solid #CCCCCC; border-right:1px solid #CCCCCC;} 
.box { margin:0; padding:5px 10px; border-left:#CCCCCC solid 1px; border-right:#CCCCCC solid 1px; font-size:12px}

</style>

<div id="container" style="background: #fff"> 
      <b class="rtop"><b class="r1"></b><b class="r2"></b><b class="r3"></b><b class="r4"></b></b> 
      <div class="box">이미지 없이 라운딩 보더 표현하기이미지 없이 라운딩 보더 표현하기이미지 없이 라운딩 보더 표현하기이미지 없이 라운딩 보더 표현하기!</div> 
      <b class="rbottom"><b class="r4"></b><b class="r3"></b><b class="r2"></b><b class="r1"></b></b>

</div>