DatabaseProcApplicationCreatedLinks
sybsystemprocssp_drv_getsortorder  31 Aug 14Defects 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)