Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UDT not nullable allows nulls?

Status
Not open for further replies.
jby1

jby1

Programmer
Apr 29, 2003
403
GB
Hi

A database I am working with has a UDT which is defined as not nullable. However, I am able to set variables of this type to be null, as well as assign null to table columns of this type.

This seems like strange behaviour to me. Can anybody tell me what setting a UDT to be not nullable actually means?

Cheers
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Will not show row with Line Type 2 1
Replies
17
Views
312
Cpreston
Cpreston
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
180
Andrzejek
Andrzejek
Lidias13
  • Locked
  • Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
125
ggriffit
ggriffit
Cpreston
  • Locked
  • Question
Not giving result but NUll
Replies
7
Views
182
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
SQL 2104 "Check For Updates" Not Listed Under Tools
Replies
0
Views
74
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top