SQLException : String or binary data would be truncated

by

In general, there isn’t a way to determine which particular statement caused the error. If you’re running several, you could watch profiler and look at the last completed statement and see what the statement after that might be, though I have no idea if that approach is feasible for you.

In any event, one of your parameter variables (and the data inside it) is too large for the field it’s trying to store data in. Check your parameter sizes against column sizes and the field(s) in question should be evident pretty quickly.

More Related Contents:

  1. How can I round a value in SQL
  2. How do I update a value in C# and SQL Server? [closed]
  3. SQL Server Char/VarChar DateTime Error [closed]
  4. Delete from two tables? [closed]
  5. How to get last inserted id?
  6. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  7. Execute Insert command and return inserted Id in Sql
  8. Adding multiple parameterized variables to a database in c#
  9. Insert entire DataTable into database at once instead of row by row?
  10. What represents a double in sql server?
  11. SQL WHERE clause matching values with trailing spaces
  12. How to retrieve data from a SQL Server database in C#?
  13. SqlBulkCopy from a List
  14. Code to validate SQL Scripts
  15. Any way to SQLBulkCopy “insert or update if exists”?
  16. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  17. SqlConnection.Close() inside using statement
  18. Generate class from database table
  19. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  20. What is passing parameters to SQL and why do I need it?
  21. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  22. Add WHERE clauses to SQL dynamically / programmatically
  23. How to pass string array in SQL parameter to IN clause in SQL
  24. Query validation using C#
  25. Use SQL Server time datatype in C#.NET application?
  26. Database Error: There is no row at position 0
  27. Generating sql code programmatically
  28. How to give ADO.NET Parameters
  29. Capturing count from an SQL query
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment