July 29, 2022 at 7:24 am
I have found an explanation of the "ISNULL" on here: https://www.w3schools.com/sql/sql_ref_sqlserver.asp
What will be a good reason to use this function and spesificaly for views?
July 29, 2022 at 10:41 am
Why not refer to documentation for what is does? As for what is a good reason to use it in a VIEW, I'm not sure what you really mean. The reason to use the function is the return the second parameter when the first is NULL. The "good" reason to use it in a VIEW is when you need that behaviour. (Though never use it on a column in your WHERE or ON, use explicit OR logic there.)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply