String will be truncated

Question

Hi Team Any mate who can advice me, i am running this query, somehow i am getting an exception 'Line 2' insert into dbo.TrainingAcademy_Courses(CourseNo, Price, Venue, CourseDetails, Description, ZoomUrl, Url, CourseInstructor) values (1, 3400.00, 'Online Virtual Event' , 'Basic Measurement Course' , '11 & 12 November 2020' , 'Upcoming Training Event.jpg' , 'Upcoming Training Event.jpg' , 'Emorgin Van Heerden' );

Sachin Singh · Answer

change description to varchar(Max) and url to nvarchar(50) clearly your url is not fixed length of 10, so you can't use nchar(10)

Sachin Singh · Answer

check your price column, it must be decimal and all other column except primary key column looks like varchar(250)

Guest User · Answer

Thanks mate, its working

Jignesh Kumar · Answer

Hi Gcobani Mkontwana, Here you are trying to insert value for Url field more then url field length that is the reason for this error. Please use this code to change lentgh of your require columns, Below query is for 2 colimns ZoomUrl and Url to change length of column. -- Increase lenth for ZoomUrl column ALTER TABLE TrainingAcademy_Courses alter COLUMN ZoomUrl nvarchar(500) null ; -- Increase lenth for Url column ALTER TABLE TrainingAcademy_Courses alter COLUMN Url nvarchar(500) null ; insert into dbo.TrainingAcademy_Courses(CourseNo, Price, Venue, CourseDetails, Description, ZoomUrl, Url, CourseInstructor) values(1, 3400.00, 'Online Virtual Event' , 'Basic Measurement Course' , N '11 & 12 November 2020' , 'Upcoming Training Event.jpg' , 'Upcoming Training Event.jpg' , 'Emorgin Van Heerden' );

Mageshwaran R · Answer

Hi Gcobani, Please try this query: insert into dbo.TrainingAcademy_Courses(CourseNo, Price, Venue, CourseDetails, Description, ZoomUrl, Url, CourseInstructor) values (1, 3400.00, 'Online Virtual Event' , 'Basic Measurement Course' , N '11 & 12 November 2020' , 'Upcoming Training Event.jpg' , 'Upcoming Training Event.jpg' , 'Emorgin Van Heerden' );

Guest User · Answer

Please check my attached db schema for these records

String will be truncated

Answers (6)