Uday, first of all, your second part does not take a set based update into account.

This might give you some problems if more than one device is updated in one statement.

For the rest, you should not use the syntax you're using. Try the following for the if statement :

IF EXISTS (SELECT DEVICE_STATE FROM DELETED where DEVICE_STATE = 'Node Down')

BEGIN ...