Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Insert query gives error in Stored Procedure

Author  Topic 

itchocks
Starting Member

44 Posts

Posted - 2005-03-02 : 23:17:05

Hi All,

In my VB 6 project, i want to use stored procedure to insert data in a table, but in my table (DataBase in SqlServer) one filed data type is "Text", in that filed i inserted bulk data means resume in text file, it works well bu using direct insert command, when ever i am trying to do same insertion process by using stored procedure it gives error like

"String Data, right truncation"

I tried remove that resume field, then it works well. In stored procedure also that resume data type is text. I want to insert resumes also.

Is there any possible solution to solve this problem, plz help me out.


Chock
   

- Advertisement -