Glad to help. Regards,
Benj On Aug 17, 2:13 pm, Cerebrus <[email protected]> wrote: > 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 -
