DatabaseProcApplicationCreatedLinks
sybsystemprocssp_localtypename  14 déc. 14Defects Propagation Dependencies

1     
2     
3     CREATE OR REPLACE PROCEDURE sp_localtypename(@sstype int)
4     as
5     
6         declare @curiso int
7         SELECT @curiso = @@isolation
8         if @@isolation = 0
9         begin
10    
11            set transaction isolation level 1
12        end
13    
14        SELECT local_type_name FROM sybsystemprocs.dbo.spt_datatype_info WHERE ss_dtype = @sstype
15    
16        if @curiso = 0
17        begin
18            set transaction isolation level 0
19        end
20        return (0)
21    


exec sp_procxmode 'sp_localtypename', 'AnyMode'
go

Grant Execute on sp_localtypename to public
go
RESULT SETS
sp_localtypename_rset_001

DEFECTS
 QTYP 4 Comparison type mismatch Comparison type mismatch: tinyint vs int 14
 TNOI 4 Table with no index sybsystemprocs..spt_datatype_info sybsystemprocs..spt_datatype_info
 MGTP 3 Grant to public sybsystemprocs..sp_localtypename  
 MGTP 3 Grant to public sybsystemprocs..spt_datatype_info  
 MUCO 3 Useless Code Useless Brackets in create proc 3
 MUCO 3 Useless Code Useless Brackets 20
 QISO 3 Set isolation level 11
 QISO 3 Set isolation level 18
 MRST 2 Result Set Marker 14
 MTR1 2 Metrics: Comments Ratio Comments: 0% 3
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 4 = 3dec - 1exi + 2 3
 MTR3 2 Metrics: Query Complexity Complexity: 13 3

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..spt_datatype_info  
writes table sybsystemprocs..sp_localtypename_rset_001