Editing ray

Title / Description

Code
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

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code