Length too important, SP truncates instead of returning an error

Imagine that we have a stored procedure with a varchar(3) parameter.

If we call it with “AZERTY” as parameter, the SP is executed as with “AZE” as parameter.

I find it really bad!

I think we should have a sql error and then if a .NET adapter calls it, an exception in its call.

This entry was posted in 7671, 9104. Bookmark the permalink.

Leave a Reply

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


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>