SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jan 2004
    Location
    Aldershot
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Null value and MSSQL

    I am creating scripts that convert data exported from Filemaker and write them to a MS SQL Server DB. If a particular field contains no data I need to insert a Null value into SQL Server, but I am having difficulty doing this as I cannot seem to find documentation on how to insert a Null value writing a SQL statement passing values in variables or elements in an array. Is this possible?

    Hope this makes sense.

  2. #2
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    Not sure about MSSQL, but shouldn't you set the default value to NULL at the table level?

    This sounds as if it is probably more of a general sql question.

    How are you moving the data from one to the other.


Bookmarks

Posting Permissions

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