1. Altering the table and change the length.
ALter table emp ALTER Column name varchar(15)
2. By using conversion we can insert the data.
Insert into emp values(1,CAST('Emily Brown' AS VARCHAR(10))
Download
0 formats
No download links available.
SQL SERVER||How to overcome String or binary data truncated error? | NatokHD