DEFECTS |
QJWI 5 Join or Sarg Without Index |
155 |
QJWI 5 Join or Sarg Without Index |
182 |
QJWI 5 Join or Sarg Without Index |
183 |
QJWI 5 Join or Sarg Without Index |
211 |
QJWI 5 Join or Sarg Without Index |
212 |
QJWI 5 Join or Sarg Without Index |
285 |
QJWI 5 Join or Sarg Without Index |
286 |
MINU 4 Unique Index with nullable columns master..sysmessages |
master..sysmessages |
MTYP 4 Assignment type mismatch @grpname: varchar(30) = varchar(255) |
260 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
145 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
160 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
186 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
216 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
240 |
MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname |
291 |
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int |
34 |
QTYP 4 Comparison type mismatch smallint = int |
34 |
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int |
156 |
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int |
158 |
TNOU 4 Table with no unique index master..spt_values |
master..spt_values |
MGTP 3 Grant to public master..spt_values |
|
MGTP 3 Grant to public master..syslogins |
|
MGTP 3 Grant to public master..sysmessages |
|
MGTP 3 Grant to public master..syssrvroles |
|
MGTP 3 Grant to public sybsystemprocs..sp_helpuser |
|
MGTP 3 Grant to public sybsystemprocs..sysalternates |
|
MGTP 3 Grant to public sybsystemprocs..sysobjects |
|
MGTP 3 Grant to public sybsystemprocs..systypes |
|
MGTP 3 Grant to public sybsystemprocs..sysusers |
|
MNER 3 No Error Check should check @@error after select into |
94 |
MNER 3 No Error Check should check return value of exec |
145 |
MNER 3 No Error Check should check @@error after select into |
150 |
MNER 3 No Error Check should check return value of exec |
160 |
MNER 3 No Error Check should check @@error after select into |
176 |
MNER 3 No Error Check should check return value of exec |
186 |
MNER 3 No Error Check should check @@error after select into |
206 |
MNER 3 No Error Check should check return value of exec |
216 |
MNER 3 No Error Check should check return value of exec |
234 |
MNER 3 No Error Check should check @@error after select into |
236 |
MNER 3 No Error Check should check return value of exec |
240 |
MNER 3 No Error Check should check return value of exec |
258 |
MNER 3 No Error Check should check return value of exec |
260 |
MNER 3 No Error Check should check return value of exec |
272 |
MNER 3 No Error Check should check @@error after select into |
279 |
MNER 3 No Error Check should check return value of exec |
291 |
MUCO 3 Useless Code Useless Brackets |
48 |
MUCO 3 Useless Code Useless Brackets |
57 |
MUCO 3 Useless Code Useless Brackets |
60 |
MUCO 3 Useless Code Useless Brackets |
83 |
MUCO 3 Useless Code Useless Brackets |
95 |
MUCO 3 Useless Code Useless Brackets |
96 |
MUCO 3 Useless Code Useless Brackets |
97 |
MUCO 3 Useless Code Useless Brackets |
98 |
MUCO 3 Useless Code Useless Brackets |
163 |
MUCO 3 Useless Code Useless Brackets |
191 |
MUCO 3 Useless Code Useless Brackets |
245 |
MUCO 3 Useless Code Useless Brackets |
261 |
MUCO 3 Useless Code Useless Brackets |
295 |
MUCO 3 Useless Code Useless Brackets |
308 |
MUCO 3 Useless Code Useless Brackets |
313 |
QCTC 3 Conditional Table Creation |
94 |
QCTC 3 Conditional Table Creation |
150 |
QCTC 3 Conditional Table Creation |
176 |
QCTC 3 Conditional Table Creation |
206 |
QCTC 3 Conditional Table Creation |
236 |
QCTC 3 Conditional Table Creation |
279 |
QISO 3 Set isolation level |
25 |
QNAJ 3 Not using ANSI Inner Join |
108 |
QNAJ 3 Not using ANSI Inner Join |
152 |
QNAO 3 Not using ANSI Outer Join |
180 |
QNAO 3 Not using ANSI Outer Join |
210 |
QNAO 3 Not using ANSI Outer Join |
283 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid} |
32 |
QPRI 3 Join or Sarg with Rooted Partial Index Use JOIN Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error} Uncovered: [dlevel] |
136 |
VUNU 3 Variable is not used @len1 |
12 |
VUNU 3 Variable is not used @len2 |
13 |
VUNU 3 Variable is not used @len3 |
14 |
MSUB 2 Subquery Marker |
31 |
MSUB 2 Subquery Marker |
76 |
MSUB 2 Subquery Marker |
198 |
MSUB 2 Subquery Marker |
229 |
MSUB 2 Subquery Marker |
251 |
MSUB 2 Subquery Marker |
254 |
MSUB 2 Subquery Marker |
267 |
MSUB 2 Subquery Marker |
301 |
MTR1 2 Metrics: Comments Ratio Comments: 30% |
6 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 57 = 64dec - 9exi + 2 |
6 |
MTR3 2 Metrics: Query Complexity Complexity: 173 |
6 |
PRED_QUERY_COLLECTION 2 {m=master..sysmessages, o=sybsystemprocs..sysobjects, sv=master..spt_values, sv2=master..spt_values, u=sybsystemprocs..sysusers} 0 |
94 |
PRED_QUERY_COLLECTION 2 {t=sybsystemprocs..systypes, t2=sybsystemprocs..systypes, u=sybsystemprocs..sysusers} 0 |
150 |