Click here to Skip to main content
15,887,346 members
Home / Discussions / Database
   

Database

 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 9:18
Member 118403633-May-16 9:18 
GeneralRe: addition having null values in between Pin
Tomas Takac3-May-16 9:51
Tomas Takac3-May-16 9:51 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 15:03
Member 118403633-May-16 15:03 
AnswerRe: addition having null values in between Pin
ZurdoDev3-May-16 9:07
professionalZurdoDev3-May-16 9:07 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 9:32
Member 118403633-May-16 9:32 
AnswerRe: addition having null values in between Pin
ZurdoDev3-May-16 9:34
professionalZurdoDev3-May-16 9:34 
GeneralRe: addition having null values in between Pin
Member 118403633-May-16 9:42
Member 118403633-May-16 9:42 
GeneralRe: addition having null values in between Pin
ZurdoDev3-May-16 9:45
professionalZurdoDev3-May-16 9:45 
Did you lookup how to use IsNull or COALESCE()?

It's very simple.

SELECT COALESCE(field1, 0)
or
SELECT IsNull(field1, 0)

If field1 is null then you will get 0. So, if you are adding them up then adding 0 will not get counted.
There are only 10 types of people in the world, those who understand binary and those who don't.

QuestionAlternatives to IBM DB2/Oracle? Pin
Member 1249383629-Apr-16 10:36
Member 1249383629-Apr-16 10:36 
AnswerRe: Alternatives to IBM DB2/Oracle? Pin
rick_lively30-Apr-16 10:40
rick_lively30-Apr-16 10:40 
NewsOmniDB - An Open Source Web Tool For Database Management and Conversion Pin
William Ivanski29-Apr-16 5:11
professionalWilliam Ivanski29-Apr-16 5:11 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
Eddy Vluggen29-Apr-16 6:36
professionalEddy Vluggen29-Apr-16 6:36 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
William Ivanski29-Apr-16 6:52
professionalWilliam Ivanski29-Apr-16 6:52 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
Eddy Vluggen29-Apr-16 7:21
professionalEddy Vluggen29-Apr-16 7:21 
GeneralRe: OmniDB - An Open Source Web Tool For Database Management and Conversion Pin
Rafael T. Castro29-Apr-16 9:34
Rafael T. Castro29-Apr-16 9:34 
Questioni want to create data base by using c++ language Pin
Member 1249285029-Apr-16 0:01
Member 1249285029-Apr-16 0:01 
AnswerRe: i want to create data base by using c++ language Pin
Eddy Vluggen29-Apr-16 0:26
professionalEddy Vluggen29-Apr-16 0:26 
AnswerRe: i want to create data base by using c++ language Pin
ZurdoDev29-Apr-16 8:09
professionalZurdoDev29-Apr-16 8:09 
QuestionChange Data Capture is not capturing before value for the Images Pin
indian14327-Apr-16 11:17
indian14327-Apr-16 11:17 
AnswerRe: Change Data Capture is not capturing before value for the Images Pin
Eddy Vluggen29-Apr-16 6:44
professionalEddy Vluggen29-Apr-16 6:44 
QuestionEnable-Migrations, I don't get it - EF6 Pin
jkirkerx23-Apr-16 13:36
professionaljkirkerx23-Apr-16 13:36 
QuestionImproving Performance of Dynamic Sql Pin
indian14319-Apr-16 12:25
indian14319-Apr-16 12:25 
SuggestionRe: Improving Performance of Dynamic Sql Pin
CHill6020-Apr-16 2:50
mveCHill6020-Apr-16 2:50 
GeneralRe: Improving Performance of Dynamic Sql Pin
indian14326-Apr-16 7:55
indian14326-Apr-16 7:55 
AnswerRe: Improving Performance of Dynamic Sql Pin
Oscar Salgado9-Aug-16 12:44
Oscar Salgado9-Aug-16 12:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.