SQL error

#1

I am trying to copy the data from one table to another table linked in
SQL. I keep getting an error message saying "the data types
nvarchar(max) and ntext are incompatible in the equal to operator" I
went into the SQL Management Server and tried to modify the codes and
am still having no luck. Any help would be appreciated.

#2

Duffey (rduffey (AT) mazakcorp (DOT) com) writes:

Quote:

I am trying to copy the data from one table to another table linked in
SQL. I keep getting an error message saying "the data types
nvarchar(max) and ntext are incompatible in the equal to operator" I
went into the SQL Management Server and tried to modify the codes and
am still having no luck. Any help would be appreciated.

The tables are on different servers?

How does your UPDATE statement look like? What is the CREATE TABLE
statement for the tables?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

On Feb 22, 5:22 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:

Quote:

Duffey (rduf... (AT) mazakcorp (DOT) com) writes:
I am trying to copy the data from one table to another table linked in
SQL. I keep getting an error message saying "the data types
nvarchar(max) and ntext are incompatible in the equal to operator" I
went into the SQL Management Server and tried to modify the codes and
am still having no luck. Any help would be appreciated.

The tables are on different servers?

How does your UPDATE statement look like? What is the CREATE TABLE
statement for the tables?

--
Erland Sommarskog, SQL Server MVP, esq... (AT) sommarskog (DOT) se

We used the importing tool in Access to import the table and data into

SQL
JobLogID int Unchecked
Notes nvarchar(MAX) Checked
Unchecked

This is what the table looks like in SQL Management.

Quote:

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

#4

On Feb 22, 3:28 pm, "Duffey" <rduf... (AT) mazakcorp (DOT) com> wrote:

Quote:

On Feb 22, 5:22 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:> Duffey (rduf... (AT) mazakcorp (DOT) com) writes:
I am trying to copy the data from one table to another table linked in
SQL. I keep getting an error message saying "the data types
nvarchar(max) and ntext are incompatible in the equal to operator" I
went into the SQL Management Server and tried to modify the codes and
am still having no luck. Any help would be appreciated.

The tables are on different servers?

How does your UPDATE statement look like? What is the CREATE TABLE
statement for the tables?

--
Erland Sommarskog, SQL Server MVP, esq... (AT) sommarskog (DOT) se

We used the importing tool in Access to import the table and data into
SQL
JobLogID int Unchecked
Notes nvarchar(MAX) Checked
Unchecked

This is what the table looks like in SQL Management.

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

ntext and text are BLOB data types. They don't work very well with
varchar. Must you use ntext? It would be much easier to work with
VARCHAR(8000) if you are allowed.

#5

Duffey (rduffey (AT) mazakcorp (DOT) com) writes:

Quote:

On Feb 22, 5:22 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Duffey (rduf... (AT) mazakcorp (DOT) com) writes:
I am trying to copy the data from one table to another table linked in
SQL. I keep getting an error message saying "the data types
nvarchar(max) and ntext are incompatible in the equal to operator" I
went into the SQL Management Server and tried to modify the codes and
am still having no luck. Any help would be appreciated.

The tables are on different servers?

How does your UPDATE statement look like? What is the CREATE TABLE
statement for the tables?

--
Erland Sommarskog, SQL Server MVP, esq... (AT) sommarskog (DOT) se

We used the importing tool in Access to import the table and data into
SQL
JobLogID int Unchecked
Notes nvarchar(MAX) Checked
Unchecked

This is what the table looks like in SQL Management.

That does not tell me much. Are you saying that one table is in Access?
(A product of which I have very little knowledge)?

I repeat: could you post the UPDATE statement, and the CREATE TABLE
statement for the tables? (Right-click in Object Explorer and select
Script To.) It's impossible to assist on guessworks only.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL error

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

SQL error - 02-22-2007 , 04:11 PM

Re: SQL error - 02-22-2007 , 04:22 PM

Re: SQL error - 02-22-2007 , 04:28 PM

Re: SQL error - 02-22-2007 , 04:32 PM

Re: SQL error - 02-23-2007 , 02:28 AM