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 *