Question and answer
"Think of a situation where null value should be allowed and a situation where it should not be allowed. What are the consequences of inappropriate null settings
NULL values cause several problems. For starters, NULL values are not the same as data values. A NULL value is basically an undefined values. On the ColdFusion end, this is not terrible as NULL values come across as empty strings (for the most part). [ But in SQL, NULL and empty string are very different and act very differently. Take the following data table for example: id name - - - - - -
- - 1 Ben 2 Jim 3 Simon 4 5 6 Ye 7 8 9 Dave 10 ]
Expert answered|papop|Points 184|
Question
Asked 8/21/2012 11:16:04 PM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
18,456,559 questions answered
Popular Conversations
In the poem "God's Grandeur," the phrase "nor can foot feel, being ...
Weegy: In the poem "God's Grandeur," the phrase "nor can foot feel, being shod" means: humans are out of touch with ...
11/27/2014 12:04:03 AM| 1 Answers
Weegy Stuff
S
L
1
L
P
C
1
P
C
1
L
P
C
1
Points 2869 [Total 14579]| Ratings 10| Comments 2769| Invitations 0|Online
S
L
Points 1472 [Total 3758]| Ratings 0| Comments 1472| Invitations 0|Offline
S
Points 842 [Total 874]| Ratings 1| Comments 832| Invitations 0|Offline
S
L
Points 777 [Total 1298]| Ratings 6| Comments 717| Invitations 0|Offline
S
1
L
1
L
P
P
L
P
Points 773 [Total 14147]| Ratings 0| Comments 773| Invitations 0|Offline
S
1
L
L
Points 273 [Total 6667]| Ratings 0| Comments 273| Invitations 0|Offline
S
L
Points 162 [Total 1458]| Ratings 3| Comments 132| Invitations 0|Offline
S
Points 102 [Total 102]| Ratings 1| Comments 92| Invitations 0|Offline
S
Points 50 [Total 50]| Ratings 0| Comments 0| Invitations 5|Offline
S
Points 46 [Total 46]| Ratings 3| Comments 6| Invitations 1|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.