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.
17,582,040 questions answered
Popular Conversations
What is the square root of 6000?
9/29/2014 2:39:45 PM| 3 Answers
A list of potential sources of information for a paper is a(n) ...
Weegy: A list of potential sources of information for a paper in annotated bibliography. User: An index to ...
9/29/2014 2:50:04 PM| 3 Answers
In the Roman Republic, ____________ did not have power in the ...
Weegy: In the Roman Republic,non-citizens did not have power in the government.
9/29/2014 5:48:03 AM| 2 Answers
-2(4x + 1)= -8x + 2
9/29/2014 7:08:45 AM| 2 Answers
The Greek word “atomos” means ...
9/29/2014 9:56:07 AM| 2 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
P
C
P
C
L
Points 3198 [Total 27596]| Ratings 8| Comments 3118| Invitations 0|Offline
S
L
1
L
P
C
1
Points 2884 [Total 9415]| Ratings 12| Comments 2764| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
P
C
Points 2659 [Total 19831]| Ratings 12| Comments 2539| Invitations 0|Offline
S
L
C
P
C
1
L
L
P
C
1
Points 2638 [Total 18577]| Ratings 18| Comments 2458| Invitations 0|Offline
S
L
1
1
1
1
L
1
L
Points 2548 [Total 12328]| Ratings 0| Comments 2548| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 917 [Total 12163]| Ratings 0| Comments 917| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
P
C
Points 864 [Total 19395]| Ratings 2| Comments 844| Invitations 0|Offline
S
L
Points 711 [Total 1380]| Ratings 0| Comments 711| Invitations 0|Offline
S
1
L
L
Points 629 [Total 5752]| Ratings 4| Comments 589| Invitations 0|Offline
S
P
C
L
P
L
1
Points 151 [Total 6208]| Ratings 2| Comments 131| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.