美文网首页
SQL Cursor

SQL Cursor

作者: richardch | 来源:发表于2017-03-27 15:16 被阅读0次
USE [KdsRelease]

declare @chartguid uniqueidentifier
declare @name nvarchar(MAX)
declare @rowStart int
declare @columnStart int
declare @rowSpan int
declare @columnSpan int
declare @chartType int
declare @Content nvarchar(MAX)
declare @startDuration int
declare @durationCount int
declare @createdBy nvarchar(50)
declare @createdTime datetime
declare @updateBy nvarchar(50)
declare @updatedTime datetime
/*declare cursor*/
declare chart_cur cursor for select * from [Charts]
/*open cursor*/
open chart_cur
fetch next from chart_cur into @chartguid,@name,@rowStart,@columnStart,@rowSpan,@columnSpan,@chartType,@Content,@startDuration,@durationCount,@createdBy,@createdTime,@updateBy,@updatedTime
while @@FETCH_STATUS = 0
    begin

        /*update [Tiles] set StartDuration = @startDuration, DurationCount = @durationCount, ChartType = @chartType where Chart_Guid= @chartguid;*/
        update [Tiles] set RowStart = @rowStart, ColumnStart = @columnStart, RowSpan = @rowSpan, ColumnSpan = @columnSpan where Chart_Guid= @chartguid and RowStart is null;

        FETCH NEXT FROM chart_cur INTO @chartguid,@name,@rowStart,@columnStart,@rowSpan,@columnSpan,@chartType,@Content,@startDuration,@durationCount,@createdBy,@createdTime,@updateBy,@updatedTime
    end
/*close cursor*/
close chart_cur;
/*release cursor*/
deallocate chart_cur;
GO

相关文章

网友评论

      本文标题:SQL Cursor

      本文链接:https://www.haomeiwen.com/subject/phsrottx.html