Optional parameters in stored procedure

[ByzantianX]

I need to make a stored procedure on sql server which should look like this:

create sp1
@prm1 text, @prm2 int, @prm3 bit.... @prmN (any data type)
as
set no count on
update tbl
set fld1=@prm1
fld2=@prm2
.
.
.
fldN=@prmN
return

but the trick is that I need those parameters to be optional. So, if I pass some value to the parameter that the procedure do not update that particular field.Is there any elegant solution which exclude loop etc.?
Thank you in advance!

 

[link9]

If I remember correctly, I believe you need to set them equal to something when you declare them, and then they become optional -- if they aren't passed, they take on the default values you have supplied...

 

[ByzantianX]

Thank you very much!
So simple so true! )