当前位置：网站首页>SQL Server cursor circular table data

SQL Server cursor circular table data

2022-04-23 10:29:00 【---Pure heart and few desires---】

Realization function , Using cursor to cycle table data , And print it out

Table data content

The idea of realization

Implementation code ：

	declare @id nvarchar(200)
	declare @name nvarchar(150)
	declare @parentid nvarchar(200)
	
	declare data  cursor for 
		select id,name,parentid from sys_org
 
	open data
		fetch next from data into @id, @name, @parentid
 
	while (@@fetch_status = 0) 
		begin
			--  Statements that need to be executed 
			print 'id:'+@id
					+'	name:'+@name
					+'	parentid:'+ @parentid
		
			fetch next from data into @id, @name, @parentid
		end
 
	close data 
	deallocate data

Execution effect