Err when insert into microsoft sql server 2000

Discussion in 'ASP .Net' started by Mike John, Nov 14, 2003.

  1. Mike John

    Mike John Guest

    I am receiving the following error when insert into the
    table.

    "String or binary data would be truncated. The statement
    has been terminated."

    the following error had occured recently
    the insert sql statement was working fine before.

    I had checked the data size against the field size. the
    data is away smaller then the size of the fields.

    And what's weird: The data I am inserting into the table x
    is from the table x.(I am just duplicating data)

    how can I work around this error?
    What is the cause of this error?

    Sincerely yours


    Mike John
     
    Mike John, Nov 14, 2003
    #1
    1. Advertisements

  2. Mike John

    Rocky Moore Guest

    "Mike John" <> wrote in message
    news:049b01c3aa51$d3b2a900$...
    > I am receiving the following error when insert into the
    > table.
    >
    > "String or binary data would be truncated. The statement
    > has been terminated."
    >
    > the following error had occured recently
    > the insert sql statement was working fine before.
    >
    > I had checked the data size against the field size. the
    > data is away smaller then the size of the fields.
    >
    > And what's weird: The data I am inserting into the table x
    > is from the table x.(I am just duplicating data)
    >
    > how can I work around this error?
    > What is the cause of this error?
    >
    > Sincerely yours
    >
    >
    > Mike John


    Do you by any change have a NCHAR or NVARCHAR in one table and a CHAR or
    NCHAR in the other?

    --
    Rocky Moore
    www.GotTheAnswerToSpam.com
    www.HintsAndTips.com - Soon to launch
     
    Rocky Moore, Nov 14, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Z2F1cmF2?=

    Uploading Data From MS Acess 2000 ti SQL server 2000

    =?Utf-8?B?Z2F1cmF2?=, Jan 9, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    1,073
    Mary Chipman [MSFT]
    Jan 9, 2006
  2. Daves
    Replies:
    1
    Views:
    587
  3. Harry Zoroc
    Replies:
    1
    Views:
    1,189
    Gregory Vaughan
    Jul 12, 2004
  4. Replies:
    1
    Views:
    657
    Jerry Stuckle
    May 17, 2006
  5. C Did
    Replies:
    3
    Views:
    4,305
    Chris Lithgow
    Jun 20, 2006
  6. Grey Alien

    SQL Server 2000 vs SQL Server Express

    Grey Alien, Jul 8, 2007, in forum: ASP .Net
    Replies:
    6
    Views:
    691
    Grey Alien
    Jul 9, 2007
  7. Denis

    Access 2000 or SQL Server 2000

    Denis, Jan 25, 2004, in forum: ASP General
    Replies:
    1
    Views:
    395
    Nicole Calinoiu
    Jan 25, 2004
  8. Terry Cooper
    Replies:
    7
    Views:
    614
    Janos Sebok
    Jun 9, 2009
Loading...