Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aravindt77
Posting Yak Master
120 Posts |
 Posted - 2007-06-18 : 02:36:28
|
| Hi All,Warm Wishes I m creating a Table for MenuItem ...and a column exist in thatable which is not a key ...type of tiny int... is it worth to specify default null rather than 0...In case of Char/Varchar how it differsThanksAravind |
|
|
pootle_flump
1064 Posts |
Posted - 2007-06-18 : 08:49:22
|
quote:
[i]I m creating a Table for MenuItem ...and a column exist in thatable which is not a key ...type of tiny int... is it worth to specify default null rather than 0...
That all depends on your requirements. The only thing I would mention is that, so long as you kept your ansi settings the same (and you will know if you haven't) then null is the default value anyway so does not need specifying. |
 |
|
|
|
|
|
Default value While table creation