INSERT NULL

• TSQL Tryer

  SSCrazy Eights

  Points: 8869

  More actions

  August 6, 2010 at 5:15 am

  #224382

  Afternoon,

  I have a set of data that I require importing to a database table called Products.

  Some of these need to mirror to what we have already in this table. Some of the fields in question are NULL.

  Is there a way that I can import NULL entries in the database?

  So in my Select part of the script I'm starting to write I have -

  SELECT

  0 AS RecordStatusID

  ,GETDATE() AS CreatedDate

  ,{ fn NOW() } AS CreatedTime

  ,2 AS CreatedByID

  ,1 AS BranchID

  --,AS ProductCode

  --,AS CatalogRef

  --,AS ProductDescription

  --,AS Units

  ,54 AS CategoryID

  --, AS Category2ID

  ,0 AS ManufacturerID

  ,NULL AS ManufacturerPartRef

  Would NULL AS ManufacturerPartRef be the correct way of doing this?

  Thanks

  Ryan

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  August 6, 2010 at 10:46 pm

  #1203828

  Answer on both questions - yes.

  _____________
  Code for TallyGenerator

• TSQL Tryer

  SSCrazy Eights

  Points: 8869

  More actions

  August 9, 2010 at 6:46 am

  #1204125

  Thanks