Good answer, Benj. Quite helpful and comprehensive! The short answer is SqlDateTime.Null.
On Aug 17, 7:41 am, Benj Nunez <[email protected]> wrote: > Hi, > > If you want to set a datetime field to null in sql server through C#, > here's how: > > http://www.c-sharpcorner.com/UploadFile/sd_patel/EnterNullValuesForDa... > > If you want to code it in sql, try the code posted by timmy here: > > http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15417 > > You can also check this one out: > > http://blogs.msdn.com/b/jaskis/archive/2008/07/09/insert-null-value-i... > > Cheers! > > Benj > > On Aug 16, 8:35 pm, Gourav <[email protected]> wrote: > > > > > Hi All, > > > Actually i have two field which are datetime format.In these one is > > compalsury and another is optional...but in sql datetime cann't be > > null...i had search on internet but i didn't get solutions how to > > nullable a datetime field in > > sql 208 & 2005 .... > > if anybody know this solutions then pls help me.I'll wait for reply... > > > Thanks > > > -- > > Warm Regards:- > > Gourav Vishnoi > > +91-9871157845 (M) > > “Smile: A curve that can set a lot of things straight."- Hide quoted text - > > - Show quoted text -
