我以前基本上没有用过游标,感觉这个没有什么用.但是有时候用到表的循环的话,还是挺好用的.现在把他的语法
写下来:
DECLARE @TNAME nvarchar(100)
DECLARE myCursor CURSOR FOR
select name from systypes
OPEN myCursor
FETCH NEXT FROM myCursor INTO @TNAME
WHILE @@FETCH_STATUS=0
BEGIN
PRINT (@TNAME)
FETCH NEXT FROM myCursor INTO @TNAME
END
CLOSE myCursor
DEALLOCATE myCursor