i am just trying to insert the million records if values into table but having the issues with this
i had the data in this formate 'PYE:879'-"sd4696' and i am not able to insert the records
Insert into Tab1 (Col1,COl2) Values ('Data','PYE:879'-"sd4696');
Can you please help on this issue
The Single quote after digit 9 is causing the issue becuse string terminates there due to that. Either remove it or add one more if one single quote is needed.
Insert into Tab1 (Col1,COl2) Values ('Data','PYE:879''-"sd4696');
Thanks guys for replying back.
The issue is single quote after 9 and this thorwing the error and the data has been fixed from the soruce after identifying the issue.