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.
| Author |
Topic |
|
sqlserverdba
Yak Posting Veteran
53 Posts |
 Posted - 2012-01-04 : 21:04:40
|
| Hi,How to display message in what rows are inserting into temporary table in sql server?error message indicates on following line:with tst (tid, code,name, hdesc) asError message:==============Executed as user: dbprod. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.Please advice.thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-05 : 09:48:07
|
| the error is straightforward. One of fields in the above list is not having sufficient length to hold data you're trying to populate. Just check lengths of fields and data populating in it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Display message in SQL procedure