SQL SERVER has the ISNULL function and function COALESCE that makes your code much more elegant and clean.
Your code would look like this.
declare @CLIENTES table
(
id int,
Nome varchar(100)
)
INSERT INTO @CLIENTES VALUES
(1, NULL),
(2, 'Jõao')
SELECT id, ISNUll(Nome, 'Meu Nome') as 'Com ISNUll', COALESCE(Nome, 'Meu Nome') as 'com COALESCE'
FROM @CLIENTES
DECLARE @Minha_Var VARCHAR(70)
SELECT @Minha_Var = ISNUll(Nome, 'Meu Nome') FROM @CLIENTES WHERE Id = 1
SELECT @Minha_Var = COALESCE(null, 'Meu Nome') FROM @CLIENTES WHERE Id = 1
SELECT ISNULL(null, 'Meu Nome') AS Using_ISNULL
SELECT COALESCE(null, 'Meu Nome') AS Using_ISNULL