ALTER PROCEDURE [dbo].[CM_ALLCODE_GetByCDNAME](@CD_NAME nvarchar(100),@CDTYPE nvarchar(15))
AS
BEGIN
	SELECT * FROM CM_ALLCODE WHERE CDNAME = @CD_NAME AND (@CDTYPE = '' OR @CDTYPE IS NULL OR CDTYPE = @CDTYPE);
END