xxxxx

Sql code posted by ddd
created at 10 May 07:24, updated at 12 May 13:24

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
declare @guid varchar(50)
declare cur cursor for select guid from 业务表名
open cur
fetch next from cur into @guid
while @@fetch_status = 0
begin
    delete SYS_INST_PRCS where taskid = @guid
    delete SYS_INST_TASKS where task_id = @guid
    delete SYS_INST_SHARE where taskid = @guid
    delete sys_SignMate where taskid = @guid
    delete 业务表名 where guid = @guid
    fetch next from cur into @guid
end
close cur
deallocate cur
440 Bytes in 2 ms with coderay