I went through the wizard and add a table adapter which references a stored procedure. This stored proc has 2 input variables, one of which can be null. If I set the option for this second var to be null, save the table adapter, then view the code, I see the following:
Code: Select all
And why is there a space before the parameter name?
Another thing I've seen is it's pulling the character ` from my stored procedure, but then complains it can't find a variable to insert into.