Good day!!
I was wondering if it is possible to put an if else statement inside a where clause of an sql statement... you see i would like my update statement to do this:
update trial_clear set num = @count2 /* @count2 is a integer passed*/
where
if (select top 1 def from trial_clear where num is NULL) is NULL
def is NULL
else
def = @def /*given value*/
please do help me... i would appreciate it much!!