SQL: Ejemplos para declarar Variables de distintos Tipos de Dato y evaluar valores Nulos

vartiables.sql

DECLARE @entero INT
SET @entero = NULL
SELECT ISNULL(@entero, 0) AS Valor

DECLARE @decimal DECIMAL(10,2)
SET @decimal = NULL
SELECT ISNULL(@decimal, 0.00) AS Valor

DECLARE @cadena VARCHAR(50)
SET @cadena = NULL
SELECT ISNULL(@cadena, 'Texto predeterminado') AS Valor

DECLARE @fecha DATETIME
SET @fecha = NULL
SELECT ISNULL(@fecha, GETDATE()) AS Valor

DECLARE @booleano BIT
SET @booleano = NULL
SELECT ISNULL(@booleano, 0) AS Valor

DECLARE @moneda MONEY
SET @moneda = NULL
SELECT ISNULL(@moneda, 0.00) AS Valor