Error string or binary data would be truncated by update in mssql server

Dung Do Tien Mar 18 2020 468

I have a table as below :

 CREATE TABLE News(
  Id INT IDENTITY(1,1) NOT NULL,
  Title NVARCHAR(100) NOT NULL,
  ShortContent NVARCHAR(1000) NULL
)

In this table have to 100k records and I need update Title column value same with ShortContent column and this is my query:

 UPDATE News SET Title  =  ShortContent

 But I get an error string or binary data would be truncated. the statement has been terminated. Pls leave a comment if you have any suggestions.

Have 1 answer(s) found.
  • D

    Dung Do Tien Mar 18 2020

    Great question

    If you attention you will find that there are two points of interest.

    1. The data type of columns - They are the same

    2. Length of columns - They are the difference

     

     Title NVARCHAR(100) NOT NULL,
ShortContent NVARCHAR(1000) NULL

    In your case,  the reason to get this error is points 2, you only need to set length of them are the same. It will be working for you.

Related Q&A May You Like

  1. MySql throw no database selected, select the default DB to be used by double-clicking its name
  2. How to generate whole sql database script in MySql Workbench
  3. Error querySrv ENODATA _mongodb._tcp.456d in MongoDB Compass
  4. What is best way to convert datetime to date in Sql Server?
  5. How to compare date without time with now() in PostgreSQL?
  6. MySQL Error Code: 1175. safe update mode update a table without a WHERE
  7. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements in MySQL
  8. ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL
  9. Calculating distance between two positions(lat, long) in SQL Server
  10. MySQL Error: 'Access denied for user 'root'@'localhost'
  11. Error: /opt/lampp/bin/mysql.server: 264: kill: No such process
  12. How to get the total of current connection in PostgreSQL?
  13. How to backup and restore MSSQL Server database in Ubuntu
  14. ERROR: OFFSET must not be negative in PostgreSQL
  15. How to update top N records for a table in PostgreSQL?
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close