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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy