SQL Server에서 Cursor를 사용하는 예제...CREATE TABLE #a(
q1 VARCHAR(5000)
);
INSERT INTO #a VALUES('SELECT GETDATE()');
INSERT INTO #a VALUES('SELECT GETDATE()');
INSERT INTO #a VALUES('SELECT GETDATE()');
INSERT INTO #a VALUES('SELECT GETDATE()');
INSERT INTO #a VALUES('SELECT GETDATE()');
DECLARE @query VARCHAR(5000)
DECLARE CurQuery CURSOR
FOR
SELECT * FROM #a
OPEN CurQuery
FETCH NEXT
FROM CurQuery
INTO @query
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC(@query) FETCH NEXT
FROM CurQuery
INTO @query
END --end of while
CLOSE CurQuery
DEALLOCATE CurQuery
'Dev & Mng' 카테고리의 다른 글
| TortoiseSVN Ignore Pattern (0) | 2007/05/29 |
|---|---|
| SQLServer Cursor Example (0) | 2007/04/23 |
| Gleam™님의 미투데이 - 2007년 4월 17일 (0) | 2007/04/18 |
| ASP의 DB Connection Timeout (0) | 2007/04/11 |
