|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
String or binary data will be truncated. How?Hi there,
I am having trouble with a stored procedure that is reporting a data truncation error when I insert into table. How can there be data truncation when I am using the same local variable types in the insert statement as are in the table structure? Why dont you post your code here? Or, if you prefer, example and we can look
at it. It seems there is at least some implicit conversion going on but thats just a guess.... MC Show quote "Waldy" <wa***@notmail.com> wrote in message news:u9kDbhCnGHA.4620@TK2MSFTNGP05.phx.gbl... > Hi there, > I am having trouble with a stored procedure that is reporting > a data truncation error when I insert into table. How can there be data > truncation when I am using the same local variable types in the insert > statement as are in the table structure? > Can you post DDL pls!
Show quote "Waldy" <wa***@notmail.com> wrote in message news:u9kDbhCnGHA.4620@TK2MSFTNGP05.phx.gbl... > Hi there, > I am having trouble with a stored procedure that is reporting > a data truncation error when I insert into table. How can there be data > truncation when I am using the same local variable types in the insert > statement as are in the table structure? > "Immy" <therealasianb***@hotmail.com> wrote in message Maybe, if I knew what a DDL was...news:e%23wAMkCnGHA.4728@TK2MSFTNGP05.phx.gbl... > Can you post DDL pls! Post your T-SQL code. The one you're using to insert data. If its (too) big,
edit it and post sample code with the same problem. MC Show quote "Waldy" <wa***@notmail.com> wrote in message news:ekdnlnCnGHA.4540@TK2MSFTNGP02.phx.gbl... > > "Immy" <therealasianb***@hotmail.com> wrote in message > news:e%23wAMkCnGHA.4728@TK2MSFTNGP05.phx.gbl... >> Can you post DDL pls! > > Maybe, if I knew what a DDL was... > with the structure of the table you are trying to insert into too please :)
Show quote "MC" <marko_culo#@#yahoo#.#com#> wrote in message news:e$yaDqCnGHA.4540@TK2MSFTNGP02.phx.gbl... > Post your T-SQL code. The one you're using to insert data. If its (too) > big, edit it and post sample code with the same problem. > > MC > > > "Waldy" <wa***@notmail.com> wrote in message > news:ekdnlnCnGHA.4540@TK2MSFTNGP02.phx.gbl... >> >> "Immy" <therealasianb***@hotmail.com> wrote in message >> news:e%23wAMkCnGHA.4728@TK2MSFTNGP05.phx.gbl... >>> Can you post DDL pls! >> >> Maybe, if I knew what a DDL was... >> > > Waldy wrote:
> "Immy" <therealasianb***@hotmail.com> wrote in message "Data Definition Language", i.e. the CREATE TABLE, etc. statements that > news:e%23wAMkCnGHA.4728@TK2MSFTNGP05.phx.gbl... >> Can you post DDL pls! > > Maybe, if I knew what a DDL was... > > you used to create the objects in your database. The error you're getting means you're attempting to stuff something into a column that it won't fit in, and without seeing your table structure and your code, there is absolutely no way we can tell you where the problem is. Do you have triggers in that table ?
Make sure that the error msg is not from triggers on that table. - Sha Anand Show quote "Waldy" wrote: > Hi there, > I am having trouble with a stored procedure that is reporting > a data truncation error when I insert into table. How can there be data > truncation when I am using the same local variable types in the insert > statement as are in the table structure? > > > Sorry guys, it was an IUE (Idiot user error)! I had two fields round the
wrong way in the insert statement.  |
|||||||||||||||||||||||
Other interesting topics