Skip to content
Advertisement

How can I set more than one condition after update statement?

I am trying to change the IsActive status to 0 if any of the other columns get deleted. I wrote this query, but when I run it I get this error:

Msg 207, Level 16, State 1, Procedure emp_Delete, Line 11 [Batch Start Line 54]
Invalid column name ’empname’.

Msg 4104, Level 16, State 1, Procedure emp_Delete, Line 11 [Batch Start Line 54]
The multi-part identifier “deleted.empname” could not be bound.

Query:

Advertisement

Answer

You can achieve the Same by using JOIN Condition

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement