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.