Search results
24 sty 2013 · Try converting the date to a string so it doesn't try to convert '' to a date: (CASE WHEN fu.SentOutDate IS NULL THEN '' ELSE CONVERT(varchar,fu.SentOutDate) END)
11 lip 2012 · CASE WHEN (ID IS NULL) THEN 'YES' ELSE 'NO' END AS ID_Value, I only have access to 2008 right now, but I'd hope that this syntax would still work in 2005 (seems like something that would be part of the original definition of CASE).
Failed to find a multi-string property (property name '%ls') of the WSFC resource with name or ID '%.*ls'. The system error code is %d. The WSFC service may not be running or may be inaccessible in its current state, or the specified arguments are invalid.
11 maj 2023 · When you try to query external tables that were created before installing this cumulative update, you receive the following error message: Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server " (null)". Object reference not set to an instance of an object.
20 kwi 2021 · 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.
16 mar 2010 · SET ANSI_NULLS OFF SELECT CASE WHEN (NULL = NULL) THEN 1 ELSE 0 END AS EqualityCheck, CASE WHEN (NULL <> NULL) THEN 1 ELSE 0 END AS InEqualityCheck, CASE WHEN (NULL IS NULL) THEN 1 ELSE 0 END AS NullComparison
17 sie 2023 · This article provides general steps to troubleshoot issues that you might experience when you apply a Cumulative Update (CU) or Service Pack (SP) to your Microsoft SQL Server instance. It also provides information on how to resolve the following error messages or conditions:
