Occasionally, the query returns no value. For a simple reason – no record from the table meets the specified conditions.
But we need some value. For example, if we build a condition on it in the Data Factory.
And how to make the query return some results even if there is none?
SELECT
ISNULL
(
(
SELECT
TOP 1 column1
FROM
table
where
column2 = value
)
,0
) AS alias
We have result value even when no result meets conditions.
