sqlserver 游标的简单示例
2016-02-19 10:48
今天天气好晴朗处处好风光，好天气好开始，图老师又来和大家分享啦。下面给大家推荐sqlserver 游标的简单示例，希望大家看完后也有个好心情，快快行动吧！
Declare @Name varchar(20)
Declare Cur Cursor For
select substring(id,0,7) as id,name from temp1
Open Cur
Fetch next From Cur Into @Id,@Name
While @@fetch_status=0
Begin
Update temp Set [c3]=@Name where [id] like @Id+'%'
Fetch Next From Cur Into @Id,@Name
End
Close Cur
Deallocate Cur
