清心寡欲的博客

实现功能，利用游标循环表数据，并打印出来表数据内容实现的思路实现代码： 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, @..

表结构如下：CREATE TABLE [dbo].[sys_org]( [id] [nvarchar](50) NOT NULL, [name] [nvarchar](100) NULL, [parentid] [nvarchar](50) NULL, CONSTRAINT [PK_sys_org] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DU

SELECT der.session_id, der.start_time, datediff(ms,der.start_time,getdate()) as ms, der.cpu_time as cputime, der.logical_reads, dest.[text] AS 'sqlcmd', der.* FROM sys.[dm_exec_requests] AS der CROSS APPLY ...