update date using case
What am I doing wrong here?
@username varchar(12)
update mytable
set date_sent = case when date_sent = null then current_timestamp end
set username = case when username = '' then @username
where id = @id
@username varchar(12)
update mytable
set date_sent = case when date_sent = null then current_timestamp end
set username = case when username = '' then @username
where id = @id
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.