Why has nobody at Microsoft thought of implementing optional parameters for functions in SQL Server? I guess backward compatibility is something they haven't heard of. I mean hell, Postgres can do it easily.

I bet you no one ever thought of that. Ever.

@ScriptCoded Or the designers are like our DBAs.

Us: "Can we have ...?"

DBAs: "No"

Us: "OK, but what about this .."

DBAs: "No"

Us: "Adding this field will make our apps easier to..."

DBAs: "No."

Us: "Can we have at least default ...oh...never mind...we'll just pass nulls to the stored procs"

DBAs to one another: "Ha ha ha...they'll all bow down to us!"