Database | Proc | Application | Created | Links |
sybsystemprocs | sp_drv_getsortorder | 31 Aug 14 | Defects Dependencies |
1 2 create procedure sp_drv_getsortorder 3 as 4 declare @id int 5 select @id = id from master.dbo.syscharsets 6 where id = (select value from master.dbo.sysconfigures where name like '%default sortorder id%') 7 and description like '%insensitive%' 8 if isnull(@id, 0) = 0 9 begin 10 select @id = 0 11 end 12 select @id 13
exec sp_procxmode 'sp_drv_getsortorder', 'AnyMode' go Grant Execute on sp_drv_getsortorder to public go
RESULT SETS | |
sp_drv_getsortorder_rset_001 |
DEFECTS | |
MINU 4 Unique Index with nullable columns master..sysconfigures | master..sysconfigures |
QTYP 4 Comparison type mismatch Comparison type mismatch: tinyint vs int | 6 |
QTYP 4 Comparison type mismatch tinyint = int | 6 |
MGTP 3 Grant to public master..syscharsets | |
MGTP 3 Grant to public master..sysconfigures | |
MGTP 3 Grant to public sybsystemprocs..sp_drv_getsortorder | |
QAFM 3 Var Assignment from potentially many rows | 5 |
QNAM 3 Select expression has no name @id | 12 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: syscharsets.csyscharsets unique clustered (id, csid) Intersection: {id} | 6 |
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysconfigures.csysconfigures unique clustered (name, parent, config) Intersection: {name} | 6 |
MRST 2 Result Set Marker | 12 |
MSUB 2 Subquery Marker | 6 |
MTR1 2 Metrics: Comments Ratio Comments: 0% | 2 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 | 2 |
MTR3 2 Metrics: Query Complexity Complexity: 12 | 2 |
DEPENDENCIES |
PROCS AND TABLES USED reads table master..syscharsets (1) reads table master..sysconfigures (1) |