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
最后编辑于 :
©著作权归作者所有,转载或内容合作请联系作者
- 文/潘晓璐 我一进店门,熙熙楼的掌柜王于贵愁眉苦脸地迎上来,“玉大人,你说我怎么就摊上这事。” “怎么了?”我有些...
- 文/花漫 我一把揭开白布。 她就那样静静地躺着,像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上,一...
- 文/苍兰香墨 我猛地睁开眼,长吁一口气:“原来是场噩梦啊……” “哼!你这毒妇竟也来了?” 一声冷哼从身侧响起,我...
推荐阅读更多精彩内容
- 1.SQL基础 数据定义语言DDL:create(创建)、alter(更改)和drop(删除)命令。 数据操纵语言...
- 环境:Windows下,已有VC++6.0的编译器。 1.新建c:\esqlc目录。 将SQL SEVER安装盘上...