inserting local variables

[btacy]

hi all,
i'm running a script which picks pieces of information from a few tables and stores them in local variables. then it inserts the information in the variables (per record)as a new record into another table.
it worked perfectly in SQL 2005, i tried to use it in SQL 2000 and it gived the following error

Server: Msg 8152, Level 16, State 2, Line 38
String or binary data would be truncated.
The statement has been terminated.

line 38 is :
INSERT INTO webuser

does anyone have an idea of what could be wrong?

 

[SQLDenis]

>>does anyone have an idea of what could be wrong?

yes, it does not fit in the table because your variables are bigger than your columns. show some DDL and it will be easier to help you

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[gmmastros]

That happens when you are trying to insert data in to a column that is not 'large' enough to accomodate it.

Ex: Column is varchar(2) and you try setting it to 'Hello World'

Create Table #Temp (Data VarChar(2))

Insert Into #Temp values('Hello World')

[tt][!]
Server: Msg 8152, Level 16, State 9, Line 3[/!]
String or binary data would be truncated.
[/tt]
The statement has been terminated.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ethorn10]

Without seeing structure or syntax, I'm going with:

your column sizes are not the same on the SQL Server 2000 version.

Any chance we could see more?

 

[SQLDenis]

3 answers, 1 minute how nice

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[btacy]

thanks all,
the problem was caused by the sizes of the variables as you pointed out.
thanks again.