Search results
15 mar 2013 · Starting with SQL Server 2022 you can use the IS [NOT] DISTINCT FROM predicate (see here) and you could re-write the OP's statement like so: SELECT first_name + CASE when last_name is not distinct from null THEN '' ELSE ' ' + last_name END AS Name FROM dbo.person
26 lip 2013 · case when b.[stat] is null then (c.[event date]+10) -- type datetime else '-' -- type varchar end as [date] You need to select one type or the other for the field, the field type can't vary by row. The simplest is to remove the ELSE '-' and let it implicitly get the value NULL instead for the second case.
11 lip 2012 · Is there any better way to write the lines below in SQL Server 2005? CASE WHEN (ID IS NULL) THEN 'YES' WHEN (ID IS NOT NULL) THEN 'NO' END AS ID_Value,
3 wrz 2024 · CASE can be used in any statement or clause that allows a valid expression. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as <select_list>, IN, WHERE, ORDER BY, and HAVING. Transact-SQL syntax conventions.
1 sie 2017 · I have a WHERE clause that I want to use a CASE expression in. However, my CASE expression needs to check if a field IS NULL. If the @UserRole variable value = 'Analyst', then the SupervisorApprovedBy column value must be NULL. Otherwise, I am saying return all data i.e. SupervisorApprovedBy = SupervisorApprovedBy.
In the T-SQL scripting language, you can use the SQL CASE statement to evaluate a condition and return one or more result expressions. This SQL Tutorial will teach you when and how you can use CASE in T-SQL statements.
11 lut 2020 · Choosing different sort orders due to the values category of the results columns or performing special aggregations for each subset of values separately are two such examples. In these cases, the CASE statement can be quite useful for your SQL Server T-SQL logic.
