I am experiencing trouble when trying to execute a certain query on a Microsoft SQL 2005 database.
The query I'm trying to execute is:
Code: Select all
INSERT INTO TBL_HISTORY ( HISTORY_ID, HISTORY_DATA, HISTORY_LWDATE, HISTORY_LWINIT ) VALUES ( '4D5B23FA2021EACP35E1NXA0300', '#CODE: ARCHIE\r\nArchie Europe bv\r\ndds\r\nGorslaan 10\r\n1441 RG PURMEREND NL\r\ntel. 0299 411 800 fax. 0299 411 888\r\n\r\nWe gaan hier even testen of het allemaal blijft werken met een\r\nlang ?\nstuk historie. Het wil namelijk nogal eens fout gaan\r\naangezien de ?\ngeweldige CLT viewer max. 65 tekens per regel kan\r\nweergeven. Nu is ?\ndit niet zo''''n probleem ware het niet dat de\r\nEACP er af en toe een ?', '20070821', 'EACP' )
If you want to test this example, I have also created a CREATE script for the table:
Code: Select all
USE [ArchieTest]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TBL_HISTORY](
[HISTORY_ID] [char](27) COLLATE Latin1_General_CS_AS NOT NULL,
[HISTORY_DATA] [image] NULL DEFAULT (null),
[HISTORY_LWDATE] [datetime] NOT NULL,
[HISTORY_LWINIT] [varchar](4) COLLATE Latin1_General_CS_AS NOT NULL,
[HISTORY_TEXT] [varchar](192) COLLATE Latin1_General_CS_AS NULL DEFAULT (null),
PRIMARY KEY CLUSTERED
(
[HISTORY_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF