Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Coalescence blues
Message
De
14/03/2017 12:17:48
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Versions des environnements
Environment:
C# 5.0
OS:
Windows 8.1
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01649038
Message ID:
01649052
Vues:
28
>>>In his code he doesn't need ?? operator, I believe.
>>
>>He does.
>
>You're right. For a minute I thought SUM will produce 0 when no results are matching, but I ran a test in SQL Server and got NULL, so that answers my original incorrect thought.

Got you, in VFP too (in 7.0?) it was also changed to return NULL and people complained at that time as I remember. Here the real problem is ?? with two non null values is an exception for C# (why in the world I don't know, that is MS after all).
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform