--请先执行以下代码,再执行你的sql
close 游标名
deallocate 游标名
close 游标名
deallocate 游标名
解决方案 »
- 查询
- sql语句如何从oracle 转到 sql server 数据库中?
- SQL SERVER搜索不到指定服务器!
- Order by 能否排序某field里的内容,如select * from table order by fiedl1 like ‘%头%’, field1 like ‘尾’ ??请赐教!!(请看例子)
- 新手的基础问题,居然让好多高手回答的语焉不详?还请大大们帮忙~
- 一个表里抽取某几条记录分组的问题
- 如何准确地判断SqlServer已安装
- sql2008 复制的相关问题
- Transact-SQL如何改写成标准的sql 语句?暴急
- 请问我只有MDF文件,没有LDF文件,如何附加数据库??
- 全文检索对象文件的文件类型
- 求一条SQL语句
FOR DELETE
AS
declare @LLPH nvarchar(30)
declare @ZLNY nvarchar(30)
declare KSDelete_Cursor cursor for select 领料批号,资料年月 from deleted
open KSDelete_Cursor
fetch next from KSDelete_Cursor into @LLPH,@ZLNY
WHILE @@FETCH_STATUS=0
begin
DELETE FROM 原毛开松入库子表 WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
UPDATE 原毛开松领料表 set 入库状态 =0 WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
DELETE FROM Temp原毛单价表KS WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
return
fetch next from KSDelete_Cursor into @LLPH,@ZLNY
end
close KSDelete_Cursor
deallocate KSDelete_Cursor
FOR DELETE
AS
declare @LLPH nvarchar(30)
declare @ZLNY nvarchar(30)
declare KSDelete_Cursor cursor for select 领料批号,资料年月 from deleted
open KSDelete_Cursor
fetch next from KSDelete_Cursor into @LLPH,@ZLNY
WHILE @@FETCH_STATUS=0
begin
DELETE FROM 原毛开松入库子表 WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
UPDATE 原毛开松领料表 set 入库状态 =0 WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
DELETE FROM Temp原毛单价表KS WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
--return 删除这句, 否则下面语句得不到执行,或根据实现改用其他方法
fetch next from KSDelete_Cursor into @LLPH,@ZLNY
end
close KSDelete_Cursor
deallocate KSDelete_Cursor
FOR DELETE
AS
declare @LLPH nvarchar(30)
declare @ZLNY nvarchar(30)
declare KSDelete_Cursor cursor for select 领料批号,资料年月 from deleted
open KSDelete_Cursor
fetch next from KSDelete_Cursor into @LLPH,@ZLNY
WHILE @@FETCH_STATUS=0
begin
DELETE FROM 原毛开松入库子表 WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
UPDATE 原毛开松领料表 set 入库状态 =0 WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
DELETE FROM Temp原毛单价表KS WHERE (领料批号 = @LLPH) and (资料年月=@ZLNY)
close KSDelete_Cursor
deallocate KSDelete_Cursor
return
fetch next from KSDelete_Cursor into @LLPH,@ZLNY
end
close KSDelete_Cursor
deallocate KSDelete_Cursor
close KSDelete_Cursor
deallocate KSDelete_Cursor