8 Answered Questions

[SOLVED] Why shouldn't we allow NULLs?

  • 2011-08-30 21:11:39
  • Thomas Stringer
  • 48025 View
  • 125 Score
  • 8 Answer
  • Tags:   database-design null

3 Answered Questions

[SOLVED] PostgreSQL multi-column unique constraint and NULL values

8 Answered Questions

4 Answered Questions

5 Answered Questions

1 Answered Questions

[SOLVED] Why does NOT IN with a set containing NULL always return FALSE/NULL?

3 Answered Questions

3 Answered Questions

[SOLVED] Why does ANSI SQL define SUM(no rows) as NULL?

1 Answered Questions

[SOLVED] WITH ROLLUP WHERE x IS NULL

2 Answered Questions

5 Answered Questions

2 Answered Questions

[SOLVED] What is the purpose of SET NULL in Delete/Update Foreign Keys constraints?

  • 2011-08-29 15:50:34
  • Derek Downey
  • 4982 View
  • 15 Score
  • 2 Answer
  • Tags:   foreign-key null

5 Answered Questions

[SOLVED] Test if any columns are NULL

1 Answered Questions

[SOLVED] How to index a query with `WHERE field IS NULL`?

2 Answered Questions

3 Answered Questions

[SOLVED] Why does COUNT() aggregate return 0 for 'NULL'?

2 Answered Questions

[SOLVED] Are many NULL columns harmful in mysql InnoDB?

1 Answered Questions

2 Answered Questions

[SOLVED] Quickly change NULL column to NOT NULL

1 Answered Questions

[SOLVED] How to get 0 as array_length() result when there are no elements

1 Answered Questions

[SOLVED] SSIS - SSAS: Missing data handling

1 Answered Questions

[SOLVED] How do I select arrays that are not empty?

3 Answered Questions

[SOLVED] Full Outer Join shows NULL when Group By is used

9 Answered Questions

[SOLVED] When to use NULL and when to use an empty string?

7 Answered Questions

[SOLVED] If a person's name is Null then how would it break the database?

2 Answered Questions

[SOLVED] NULL or NOT NULL by default?

  • 2011-01-03 23:20:37
  • BenV
  • 17834 View
  • 41 Score
  • 2 Answer
  • Tags:   mysql null

2 Answered Questions

[SOLVED] PostgreSQL UPSERT issue with NULL values

3 Answered Questions

[SOLVED] Can IS DISTINCT FROM be combined with ANY or ALL somehow?

2 Answered Questions

[SOLVED] Select column names whose entries are not null

4 Answered Questions

[SOLVED] Does NULL have a type?

  • 2011-08-06 10:58:03
  • Jack Douglas
  • 851 View
  • 14 Score
  • 4 Answer
  • Tags:   datatypes null