SQL Server Commands

SQL Server commands for date :

convert(date, start_date) != convert(date, GETDATE())

update [THIRD_PARTY_DELIVERY].[dbo].[Integration_FTP]
set ftp_url_path = REPLACE(ftp_url_path, '/pre_processed','')
where network_name = 'thomsonreuters'

MySQL Caps first

DELIMITER $$


DROP FUNCTION IF EXISTS `CAP_FIRST `$$


CREATE FUNCTION CAP_FIRST (input VARCHAR(255))


RETURNS VARCHAR(255)


DETERMINISTIC


BEGIN

DECLARE len INT;

DECLARE i INT;


SET len = CHAR_LENGTH(input);

SET input = LOWER(input);

SET i = 0;


WHILE (i < len) DO

IF (MID(input,i,1) = ' ' OR i = 0) THEN

IF (i < len) THEN

SET input = CONCAT(

LEFT(input,i),

UPPER(MID(input,i + 1,1)),

RIGHT(input,len - i - 1)

);

END IF;

END IF;

SET i = i + 1;

END WHILE;


RETURN input;

END$$


DELIMITER ;

select CAP_FIRST(item_name) from cms_menu_items;