Operand type clash inserting ntext

• stew_b

  Mr or Mrs. 500

  Points: 550

  More actions

  December 17, 2008 at 7:45 am

  #204197

  Here is what I am trying to do:

  update MyTable

  set [value] =

  (select BulkColumn FROM OPENROWSET(Bulk 'C:\MyFile.txt', SINGLE_BLOB) as blob)

  The error:

  Msg 206, Level 16, State 2, Line 3

  Operand type clash: varbinary(max) is incompatible with ntext

  The table:

  CREATE TABLE [dbo].[MyTable](

  [column1] [varchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

  [column2] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [value] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

  [column4] [datetime] NULL,

  [column5] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

  I get the same error if instead of update I do an Insert into. My confusion is I do not see the datatype "varbinary(max) in play anywhere here.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 17, 2008 at 8:36 am

  #913889

  I'm not real familiar with OPENROWSET, but it appears that the OPENROWSET command in SQL Server 2005 is using varbinary(max) as the SQL Server datat type for SINGLE_BLOB in the process.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question