Open CurName
Fetch Next From CurName into @id,@nwhile if(@@fetch_status=0)
begin
if (@id>5)
begin
Update table1
Set n=n+1
where current of CurName end
Fetch Next From CurName into @id,@n
end
Close CurName
Deallocate CurName
Fetch Next From CurName into @id,@nwhile if(@@fetch_status=0)
begin
if (@id>5)
begin
Update table1
Set n=n+1
where current of CurName end
Fetch Next From CurName into @id,@n
end
Close CurName
Deallocate CurName
解决方案 »
- 2个SQL的区别
- 这下面几个sql怎么写
- 多项选择题数据库的设计
- 为什么存储过程是正确的,而ado就过不了呢
- 像这样一个存储过程,怎么写?
- 又是动态Sql语句,类似select @code = @code + ';' + C1 from test where C2 = 'Y',多谢大家了!
- 一个datagrid中的排序显示问题
- 求季度报表where写法
- 动态SQL语句中变量问题?????
- delphi中有没有求时间差值的函数,像sql server的datediff()那样,谢谢
- @@@@@@没有连接到局域网上就无法连接SQLserver服务器,为什么(应用程序和SQLServer都装在本机器上?)
- 在线等,SQLSERVER里的数据库出现置疑.
Fetch Next From CurName into @id,@nwhile @@fetch_status=0
begin
if (@id>5)
begin
Update table1
Set n=n+1
where current of CurName end
Fetch Next From CurName into @id,@n
end
Close CurName
Deallocate CurName