CREATE PROC CD_Update
@CDID int
AS
Select ID From CDList Where CDID = @CDID
下面要循环更新符合条件的所有记录,该怎么写?
GO
@CDID int
AS
Select ID From CDList Where CDID = @CDID
下面要循环更新符合条件的所有记录,该怎么写?
GO
解决方案 »
- sql2008 r2 sp2
- 关于表变量和临时表返回结果集的问题,tomcat报错:“该语句没有返回结果集”
- 有关sql server 安全性的问题.
- 如何使用PIVOT ? 求一交叉表的SQL语句!!(SQL SERVER 2005)
- 怎麼求兩個datetime類型數據的時間差
- 感觉很难的sql查询
- [[[ SQL Server 怎么做内存数据库呢 ]]]]]]]]]
- 各位大虾,在实际工作你们管理MS-SQL数据库时是用DOS命令还是图形界面呀
- 存储过程多字段排序分页的问题?
- oracle非得安装在NT、UNIX或LINUX下吗?
- 求个满意的SQL语句...
- sql语句:取一个表的前两条记录以外的所有记录。
@CDID int
AS
declare @id int
DECLARE Cur_test CURSOR FOR
Select ID From CDList Where CDID = @CDID
OPEN Cur_test
FETCH NEXT FROM Cur_test INTO @id
while @@fetch_status = 0
begin
............ FETCH NEXT FROM Cur_test INTO @idend
GO
沒有紀錄,就不走下面的循環了,不會報錯的
[Microsoft][ODBC SQL Server Driver][SQL Server]名为 'Channel_CD' 的游标已存在。
CLOSE Cur_test
DEALLOCATE Cur_test
的
@CDID int
AS
declare @id int
DECLARE Cur_test CURSOR FOR
Select ID From CDList Where CDID = @CDID
OPEN Cur_test
FETCH NEXT FROM Cur_test INTO @id
while @@fetch_status = 0
begin
............ FETCH NEXT FROM Cur_test INTO @idend
CLOSE Cur_test
DEALLOCATE Cur_test