Saturday, 18 November 2017

Replace Empty String To Value Zero ("0")

declare @value varchar(10);
set @value = '';
SELECT COALESCE(NULLIF(@value,''), '0')

No comments:

Post a Comment

React Hooks - custom Hook

  v CustomHook Ø React allows us to create our own hook which is known as custom hook. Example – 1 localStorage Demo Step-1 Create ...