8 Answered Questions

[SOLVED] Why shouldn't we allow NULLs?

  • 2011-08-30 21:11:39
  • Thomas Stringer
  • 45999 View
  • 121 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

2 Answered Questions

1 Answered Questions

[SOLVED] WITH ROLLUP WHERE x IS NULL

5 Answered Questions

[SOLVED] Why does a UNIQUE constraint allow only one NULL?

3 Answered Questions

[SOLVED] Comparing Columns that can contain NULLS - is there a more elegant way?

  • 2012-03-16 20:12:04
  • GWR
  • 8462 View
  • 15 Score
  • 3 Answer
  • Tags:   sql-server null

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
  • 4687 View
  • 14 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'?

3 Answered Questions

[SOLVED] Why does ANSI SQL define SUM(no rows) as 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

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
  • 17630 View
  • 40 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
  • 847 View
  • 14 Score
  • 4 Answer
  • Tags:   datatypes null