DatabaseProcApplicationCreatedLinks
sybsystemprocssp_validaltlang  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
3     /*	4.8	1.1	06/14/90	sproc/src/serveroption */
4     
5     create or replace procedure sp_validaltlang
6         @name varchar(255)
7     as
8     
9     
10        if @@trancount = 0
11        begin
12            set chained off
13        end
14    
15        set transaction isolation level 1
16    
17        /* Check to see if this alias is in Syslanguages. */
18        if exists (select *
19                from master.dbo.syslanguages
20                where alias = @name)
21        begin
22            return 0
23        end
24        return 1
25    


exec sp_procxmode 'sp_validaltlang', 'AnyMode'
go

Grant Execute on sp_validaltlang to public
go
DEFECTS
 MINU 4 Unique Index with nullable columns master..syslanguages master..syslanguages
 MGTP 3 Grant to public master..syslanguages  
 MGTP 3 Grant to public sybsystemprocs..sp_validaltlang  
 QISO 3 Set isolation level 15
 MSUB 2 Subquery Marker 18
 MTR1 2 Metrics: Comments Ratio Comments: 26% 5
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 3dec - 2exi + 2 5
 MTR3 2 Metrics: Query Complexity Complexity: 11 5

DEPENDENCIES
PROCS AND TABLES USED
reads table master..syslanguages (1)  

CALLERS
called by proc sybsystemprocs..sp_addlanguage  
called by proc sybsystemprocs..sp_setlangalias