SQL error

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Duffey
    #1

    SQL error

    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.

    Tags: None
    • Erland Sommarskog
      #2
      Re: SQL error

      Duffey (rduffey@mazakc orp.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, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • Duffey
          #3
          Re: SQL error

          On Feb 22, 5:22 pm, Erland Sommarskog <esq...@sommars kog.sewrote:
          Duffey (rduf...@mazakc orp.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...@sommarsk og.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.c om/technet/prodtechnol/sql/2005/downloads/books...
          Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx

            Comment

            • Utahduck@hotmail.com
              #4
              Re: SQL error

              On Feb 22, 3:28 pm, "Duffey" <rduf...@mazakc orp.comwrote:
              On Feb 22, 5:22 pm, Erland Sommarskog <esq...@sommars kog.sewrote:Duf fey (rduf...@mazakc orp.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...@sommarsk og.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.c om/technet/prodtechnol/sql/2005/downloads/books...
              Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/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.

                Comment

                • Erland Sommarskog
                  #5
                  Re: SQL error

                  Duffey (rduffey@mazakc orp.com) writes:
                  On Feb 22, 5:22 pm, Erland Sommarskog <esq...@sommars kog.sewrote:
                  >Duffey (rduf...@mazakc orp.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...@sommarsk og.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@sommarsk og.se

                  Books Online for SQL Server 2005 at
                  http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                  Books Online for SQL Server 2000 at
                  http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                    Comment

                    Previous template Next
                    Working...