Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Question Unanswered: inserting null values into smalldatetime

    hi

    how can we insert null into a small datetime field (from client application VB)
    Cheers....

    baburajv

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Insert into table values (null);
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Originally posted by r123456
    Insert into table values (null);
    that only works if the field in question happens to be the only field in the table

    insert into thetable (foo, bar, datetimefld, qux, fap)
    values ( 21, 'fred', null, 42, 'okay')
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •