sql server question

Results 1 to 3 of 3

Thread: sql server question

  1. #1
    Join Date
    Dec 1969

    Default sql server question

    i have to export my data from tables into csv files.<BR>anyone know how i can do this WITH any null fields being written out as null(or flagged in some way), cos using the dts wizard it just leaves any null fields blank, eg: "" <BR><BR>many thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: sql server question

    Use DTS, but use a query to specify the data you want to export, and just the use the ISNULL() function to replace null values.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default why??

    If it is blank in your .csv it IS NULL. In SQL it says &#060;NULL&#062; but ... wht do you need to do.<BR>If there is a string value that is only a space I think SQL says nothing but it is a space if it is a string field.

Posting Permissions

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