Advertisement
Advertisement
| 07.02.2008 at 02:38PM PDT, ID: 23535220 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: |
alter proc test as declare @temp_salary integer , @emp_no integer , @salary integer declare cur_emp CURSOR for select emp_no, salary from emp order by emp_no open cur_emp fetch next from cur_emp into @emp_no, @salary while @@fetch_status =0 begin if @emp_no =1 begin update emp set rem_salary = 1000 - salary where emp_no = @emp_no print '2 emp no is ' end end close cur_emp deallocate cur_emp commit |