SQL SERVER游标遍历对象

来源:互联网 发布:asp.net商城系统源码 编辑:程序博客网 时间:2024/06/07 01:44
DECLARE @TabName VARCHAR(100)DECLARE test_Cursor CURSOR LOCAL FOR SELECT Name FROM SysObjects Where XType='U' ORDER BY NameOPEN test_Cursor FETCH NEXT FROM test_Cursor INTO @TabName WHILE @@FETCH_STATUS = 0 BEGINPRINT @TabName;FETCH NEXT FROM test_Cursor INTO @TabNameENDCLOSE test_Cursor DEALLOCATE test_Cursor