Hi - I would be grateful for any knowledge regarding the following.
Whilst QAing Stored Procedures developed by colleagues, I noticed the
following 'superflous' parameter specifications:-
1) "Modifies SQL Data" - where the Stored Procedure is Select only.
In other words, the parameter should have been specified "Reads SQL
Data"
2) Result Sets 'n', where 'n' is > 0 - where the Stored Procedure does
not contain a Cursor.
In other words, the parameter should have been specified "Result Sets
0".
Clearly, the above incorrect parameter specifications still work.
However, can either of them have any adverse impact on Performance,
Concurrency or any other operational attribute?
Thanks