Project

General

Profile

Download (221 Bytes)

CM_ALLCODE_GetByCDNAME.txt

Truong Nguyen Vu, 11/02/2020 05:36 PM

 
1 

    		
  

  

    
      2
    
    
      
ALTER PROCEDURE [dbo].[CM_ALLCODE_GetByCDNAME](@CD_NAME nvarchar(100),@CDTYPE nvarchar(15))


    		
  

  

    
      3
    
    
      
AS


    		
  

  

    
      4
    
    
      
BEGIN


    		
  

  

    
      5
    
    
      
	SELECT * FROM CM_ALLCODE WHERE CDNAME = @CD_NAME AND (@CDTYPE = '' OR @CDTYPE IS NULL OR CDTYPE = @CDTYPE);


    		
  

  

    
      6
    
    
      
END