hi.i have a table that contains id,header,content,image fileds. id is primary key. Other fields are string fields(varchar). i keep image's path on the image field. update stored proc of my is like this:
create procedure Upd_Info
update Info set header=@hea,content=@cont,image=@im
if i don't give value a field on update proc running,it gives null value that field.(this is normal for this proc)
what i want to do is this: if i don't give value to the filed, that fied will be protect old value. Or else it takes new value.
for example, a row has value of (aa,qqq,img/p.jpg)
if i runs update proc parameters like (ww,cc) values, i want image filed doesn't change. row wil be remain with ww,cc,img/p.jpg values.
i hope, i can express my problem properly. Thanks.