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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2005-03-31 : 07:51:42
|
| How do I enter a null by typing it directly into a sql table. The design of it allows nulls, but it is a smalldatetime field. |
|
|
ijprasad
Starting Member
29 Posts |
Posted - 2005-03-31 : 07:56:38
|
| in query you can use NULL as key value.In enterprise manager you need to leave it as blankInderjeet |
 |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2005-03-31 : 08:31:32
|
| I have a date in the field at present. I want to delete this date and leave a null or zero length string. If I just delete the date by highlighting it and pressing delete then it will not let me do this. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-31 : 08:38:15
|
| See, this is why EM is bad. Use the SQL query analyzer.UPDATE yourcolumn SET yourdatefield = NULL WHERE yourcolumnskeyvalue = whatever-------Moo. :) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-03-31 : 08:40:08
|
| Highlight the date and Press Ctrl+0MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Enter null