Update using cursor in SQL Server

Question

I have two tables department and employee.

In the department table I have three columsn: DEP_ID, NAME, HIKEINPERCENT

In the employee table I have four columns: EMP_ID, DEP_ID, EMP_NAME, SALARY

Now if I update the HIKEINPERCENT in the department table, it should update the SALARY of the employees in the employee table by using CURSOR in SQL Server.

PLS GUIDE WITH EXPLANATION..

@marc_s: cursors and all caps in questions often go together. — Quassnoi
– Quassnoi, Commented Nov 2, 2012 at 12:41
Avoid cursors in tsql if possible. In plsql they are good, but in tsql they are just a slow mess. — vinczemarton
– vinczemarton, Commented Nov 2, 2012 at 13:12
@SoonDead - Any stats on that? I would have assumed cursors are to be avoided in plsql too. One of the issues with cursors in TSQL is simply that cursors is an imperative approach whereas a declarative set based approach allows the query as a whole to be optimised. — Martin Smith
– Martin Smith, Commented Nov 2, 2012 at 13:19

Dominic Goulet · Accepted Answer · 2012-11-02 12:59:17Z

1

Don't use a cursor. If you update the department HIKEINPERCENT field, you should have the DEP_ID to do so, something like :

update department set HIKEINPERCENT = @someNewValue where DEP_ID = @DepartementId

Then, you should update the SALARY in the employee table using something like :

update employee set SALARY = @SomeCrazyNewValue where DEP_ID = @DepartmentId

If this does not help you, please provide more specific info in the OP.

answered Nov 2, 2012 at 12:59

Dominic Goulet

8,1437 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update using cursor in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related