您现在的位置是：网站首页> 编程资料编程资料
sqlserver 游标的简单示例_MsSql_
2023-05-26
435人已围观
简介 sqlserver 游标的简单示例_MsSql_
Declare @Id varchar(20)
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
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
您可能感兴趣的文章:
相关内容
- SQL SERVER性能优化综述(很好的总结,不要错过哦)第1/3页_MsSql_
- SQL Server常用管理命令小结_MsSql_
- mssql无数据库日志文件恢复数据库的方法第1/2页_MsSql_
- MSsql每天自动备份数据库并每天自动清除log的脚本_MsSql_
- 用SQL建立索引的方法步骤_MsSql_
- SQL语句实现SQL Server 2000及Sql Server 2005日志收缩(批量)_MsSql_
- sql高级技巧几个有用的Sql语句_MsSql_
- 一些SQL Server存储过程参数及例子_MsSql_
- SQL Server下几个危险的扩展存储过程_MsSql_
- MSSQL数据类型及长度限制详细说明_MsSql_
