Reviewer always need some guidelines to review any kind of program. When you write a COBOL program and you send if for review, then, reviewer has a question in his mind that he will look for guidelines. Top 5 guidelines help you to review program written in SQL is very easy.
With checklist you can review SQL program quickly
Below is really a checklist for you and best practices to review SQL program. In general these are applied to any high level language like Java, C# etc. and not only COBOL.
- The Order of SQL Query Execution Read Today
- ALTER statement different SQL Queries you need to modify objects
- Ordering SQL query results using DESC Vs ASC