Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_getschemas | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_ijdbc_getschemas 4 */ 5 6 CREATE PROCEDURE sp_ijdbc_getschemas 7 as 8 9 if @@trancount = 0 10 begin 11 set chained off 12 end 13 14 set transaction isolation level 1 15 16 17 delete #tmp_getschemas 18 19 insert #tmp_getschemas 20 select TABLE_SCHEM = name from sysusers where suid >= - 2 order by name 21 22
exec sp_procxmode 'sp_ijdbc_getschemas', 'AnyMode' go Grant Execute on sp_ijdbc_getschemas to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getschemas | |
MGTP 3 Grant to public sybsystemprocs..sysusers | |
MNER 3 No Error Check should check @@error after delete | 17 |
MNER 3 No Error Check should check @@error after insert | 19 |
QISO 3 Set isolation level | 14 |
MTR1 2 Metrics: Comments Ratio Comments: 5% | 6 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 | 6 |
MTR3 2 Metrics: Query Complexity Complexity: 11 | 6 |
DEPENDENCIES |
PROCS AND TABLES USED reads table sybsystemprocs..sysusers writes table tempdb..#tmp_getschemas (1) |