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
网友评论