2013年1月11日
使用游标循环表的简单DEMO
摘要： DECLARE @Customer_Name VARCHAR(500)DECLARE perCursor CURSOR FOR SELECT Name FROM PersonOPEN perCursorFETCH NEXT FROM perCursor into @Customer_Name WHILE @@FETCH_STATUS = 0 BEGIN print @Customer_Name FETCH NEXT FROM perCursor into @Customer_Name ENDCLOSE perCursorDEALLOCATE perCursor 阅读全文
posted @ 2013-01-11 12:42 Vincent.Dr 阅读(165) 评论(0) 推荐(0)