DZone Database Zone
Finding Code Smells Using SQL Prompt: Procedures That Lack Schema-Qualification
SQL Prompt implements a static code analysis rule, PE001, which will check code automatically during development and testing work for occurrences of a stored procedure being called via the EXECUTE command without the schema being specified.
Even when you don't have to qualify the name of a stored procedure — that is, whenever the procedure is in your default schema — performance is slightly better if you specify the schema and it makes the code more intelligible to others, more consistent, and easier to refactor.
No comments:
Post a Comment