in reply to DBI->MS SQL, optional parameters to stored procedures

Can you write something as 
if @Optional is NULL then @Optional = 0;

[download]
into your stored procedure?

In Section Seekers of Perl Wisdom