Execution of Stored Procedure does not return value problem

Hello everyone,

If you have developed a Stored Procedure and unexpectedly it does not return value you may consider to check the parameter definitions of your SP.

I was omitting the size of the nvarchar type parameters and after defining size of nvarchar parameters my Stored Procedures worked as expectedly.

So, If you are facing an issue like that you may want to define size of nvarchar parameters like following definition.

@myparameter nvarchar(100)

Hope that helps!

Leave a Reply

Your email address will not be published. Required fields are marked *