Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sb_rkarnati
Starting Member
4 Posts |
 Posted - 2010-05-13 : 07:57:06
|
| Hi,For one of the projects we have hundreds of SQL programs (procedures, functions, scipts etc.) that we need to review for correctness of the code.We are trying to identify some tools that would review all these programs and provide output in PDF or HTML formats.Please let me know if anyone knows of any code review tools for SQL programs.THanksRS |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-05-13 : 08:56:28
|
| by "correctness" do you mean - bad spellings? - adherence to in-house standard naming conventions? - good practice in query structure? - poor/good performing queries?www.red-gate.com provide a tool which could list all your code - and especially good at assisting version management/migrationother vendors supply some "make SQL code pretty" type tools.I haven't heard of anything that measures conformance to naming standards/query layout (in SQL)...www.vblaw.com does something in theVB world.poor/good executing code only gets resolved by experience. |
 |
|
|
sb_rkarnati
Starting Member
4 Posts |
Posted - 2010-05-14 : 00:19:41
|
| Thanks Andrew for the reply. By 'Correctness' I mean..checking the code aganist conformance to standard sql rules and custom rules (which we should be able to create, to reflect the organizational standards and policies). Also, the tool should check for logic issues like redundant code, unused code, unused variables, issues with logic (like cyclic dependency etc.)Please let me know if there are any tools that do these kinds of checks for the SQL code.Thanks againRS |
|
|
|
|
|
|
SQL Code analysis tools