I'm trying to create a procedure to insert the current date if the value in a date column is null ~ in my example releasedate
my code however isn't working at all ~
create procedure releasepatient
@rel date = getdate
select patient.releaseDate from patient
if releaseDate is null
insert into patient (releasedate) values (@rel) ;
any ideas on modifying this?