blocks|key|1361380|text|一般而言，没有办法确定是哪条特定语句导致了错误。如果您正在运行多个语句，您可以查看profiler并查看最后完成的语句，看看后面的语句可能是什么，尽管我不知道这种方法对您是否可行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1361381|在任何情况下，您的一个参数变量(以及其中的数据)对于它试图存储数据的字段来说都太大了。检查参数大小和列大小，相关字段应该很快就会显示出来。|1361382|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

blocks|key|1576541|text|这取决于您是如何进行插入调用的。全部作为一个调用，还是作为事务中的单个调用？如果是单独的调用，则为yes+(当您迭代调用时，捕获失败的调用)。如果一个大的调用，那么不。SQL正在处理整个语句，所以它不在代码的控制范围之内。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1576542|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It depends on how you are making the Insert Calls. All as one call, or as individual calls within a transaction? If individual calls, then yes (as you iterate through the calls, catch the one that fails). If one large call, then no. SQL is processing the whole statement, so it's out of the hands of the code.

blocks|key|1576549|text|BEGIN+TRY
++++INSERT+INTO+YourTable+(col1,+col2)+VALUES+(@val1,+@val2)
END+TRY
BEGIN+CATCH
++++--print+or+insert+into+error+log+or+return+param+or+etc...
++++PRINT+'@val1='%2BISNULL(CONVERT(varchar,@val1),'')
++++PRINT+'@val2='%2BISNULL(CONVERT(varchar,@val2),'')
END+CATCH|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1576550|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>BEGIN TRY
 INSERT INTO YourTable (col1, col2) VALUES (@val1, @val2)
END TRY
BEGIN CATCH
 --print or insert into error log or return param or etc...
 PRINT '@val1='+ISNULL(CONVERT(varchar,@val1),'')
 PRINT '@val2='+ISNULL(CONVERT(varchar,@val2),'')
END CATCH
</code></pre>

blocks|key|1576578|text|当SQL+Server列的数据类型的长度小于输入到条目表单中的数据的长度时，就会发生这种类型的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1576579|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This type of error occurs when the datatype of the SQL Server column has a length which is less than the length of the data entered into the entry form.

blocks|key|1576622|text|使用Linq+To+SQL，我通过记录上下文进行了调试，例如。然后，Context.Log+=+Console.Out扫描SQL以检查是否有明显的错误，有两个错误：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1576623|--+@p46:+Input+Char+(Size+=+-1;+Prec+=+0;+Scale+=+0)+[some+long+text+value1]
--+@p8:+Input+Char+(Size+=+-1;+Prec+=+0;+Scale+=+0)+[some+long+text+value2]|code-block|syntax|javascript|1576624|我通过根据值扫描表模式找到的最后一个字段是nvarchar(20)，但值是22个字符|1576625|--+@p41:+Input+NVarChar+(Size+=+4000;+Prec+=+0;+Scale+=+0)+[1234567890123456789012]|1576626|entityMap^0|Y|P|0|0|0|0|2B|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

With Linq To SQL I debugged by logging the context, eg. <code>Context.Log = Console.Out</code>
Then scanned the SQL to check for any obvious errors, there were two:

<pre><code>-- @p46: Input Char (Size = -1; Prec = 0; Scale = 0) [some long text value1]
-- @p8: Input Char (Size = -1; Prec = 0; Scale = 0) [some long text value2]
</code></pre>

the last one I found by scanning the table schema against the values, the field was nvarchar(20) but the value was 22 chars

<code>-- @p41: Input NVarChar (Size = 4000; Prec = 0; Scale = 0) [1234567890123456789012]</code>

blocks|key|1361528|text|当您必须放入的字符或值多于在数据库表中指定的字符或值时，通常会发生这种类型的错误，例如:您指定了transaction_status+varchar(10)，但实际上您试图存储包含19个字符的_transaction_status。这就是您在此代码中遇到此类错误的原因|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1361529|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

this type of error generally occurs when you have to put characters or values more than that you have specified in Database table like in that case: you specify
 transaction_status varchar(10)
 but you actually trying to store
_transaction_status 
which contain 19 characters. that's why you faced this type of error in this code

blocks|key|1576748|text|这也可能是因为您试图将一个null值放回到数据库中。因此，您的某个事务中可能有空值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1576749|entityMap^0|D|4|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

It could also be because you're trying to put in a <code>null</code> value back into the database. So one of your transactions could have nulls in them.

blocks|key|1361603|text|通常情况下，您插入的值大于最大允许值。例如，数据列最多只能包含200个字符，但您插入的是201个字符的字符串|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1361604|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Generally it is that you are inserting a value that is greater than the maximum allowed value. Ex, data column can only hold up to 200 characters, but you are inserting 201-character string

blocks|key|1576868|text|在我们自己的例子中，我增加了sql表允许的字符或字段大小，它小于从前端发布的字符总数。因此，问题就解决了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1576869|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In our own case I increase the sql table allowable character or field size which is less than the total characters posted from the front end. Hence that resolve the issue.

blocks|key|1361673|text|只需在c#.net中使用这个:+MessageBox.Show(cmd4.CommandText.ToString())；，这将显示主查询，复制它并在数据库中运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1361674|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Simply Used this:
 MessageBox.Show(cmd4.CommandText.ToString());
in c#.net and this will show you main query , Copy it and run in database .

blocks|key|1361691|text|看看这个要点。https://gist.github.com/mrameezraja/9f15ad624e2cba8ac24066cdf271453b。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1361692|public+Dictionary<string,+string>+GetEvilFields(string+tableName,+object+instance)
++++{
++++++++Dictionary<string,+string>+result+=+new+Dictionary<string,+string>();

++++++++var+tableType+=+this.Model.GetEntityTypes().First(c+=>+c.GetTableName().Contains(tableName));

++++++++if+(tableType+!=+null)
++++++++{
+++++++++++int+i+=+0;

+++++++++++foreach+(var+property+in+tableType.GetProperties())
+++++++++++{
+++++++++++++++var+maxlength+=+property.GetMaxLength();
+++++++++++++++var+prop+=+instance.GetType().GetProperties().FirstOrDefault(_+=>+_.Name+==+property.Name);

+++++++++++++++if+(prop+!=+null)
+++++++++++++++{
+++++++++++++++++++var+length+=+prop.GetValue(instance)?.ToString()?.Length;

+++++++++++++++++++if+(length+>+maxlength)
+++++++++++++++++++{
++++++++++++++++++++++++result.Add($"{i}.Evil.Property",+prop.Name);
++++++++++++++++++++++++result.Add($"{i}.Evil.Value",+prop.GetValue(instance)?.ToString());
++++++++++++++++++++++++result.Add($"{i}.Evil.Value.Length",+length?.ToString());
++++++++++++++++++++++++result.Add($"{i}.Evil.Db.MaxLength",+maxlength?.ToString());
++++++++++++++++++++++++i%2B%2B;
++++++++++++++++++++}
+++++++++++++++}
++++++++++++}
+++++++}

+++++++return+result;
++++}|code-block|syntax|javascript|1361693|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/mrameezraja/9f15ad624e2cba8ac24066cdf271453b^0|7|1W|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Checkout this gist.
<a href="https://gist.github.com/mrameezraja/9f15ad624e2cba8ac24066cdf271453b" rel="nofollow noreferrer">https://gist.github.com/mrameezraja/9f15ad624e2cba8ac24066cdf271453b</a>.
<pre><code>public Dictionary&lt;string, string&gt; GetEvilFields(string tableName, object instance)
 {
 Dictionary&lt;string, string&gt; result = new Dictionary&lt;string, string&gt;();

 var tableType = this.Model.GetEntityTypes().First(c =&gt; c.GetTableName().Contains(tableName));

 if (tableType != null)
 {
 int i = 0;

 foreach (var property in tableType.GetProperties())
 {
 var maxlength = property.GetMaxLength();
 var prop = instance.GetType().GetProperties().FirstOrDefault(_ =&gt; _.Name == property.Name);

 if (prop != null)
 {
 var length = prop.GetValue(instance)?.ToString()?.Length;

 if (length &gt; maxlength)
 {
 result.Add($&quot;{i}.Evil.Property&quot;, prop.Name);
 result.Add($&quot;{i}.Evil.Value&quot;, prop.GetValue(instance)?.ToString());
 result.Add($&quot;{i}.Evil.Value.Length&quot;, length?.ToString());
 result.Add($&quot;{i}.Evil.Db.MaxLength&quot;, maxlength?.ToString());
 i++;
 }
 }
 }
 }

 return result;
 }

</code></pre>

I have a C# code which does lot of insert statements in a batch. While executing these statements, I got "String or binary data would be truncated" error and transaction roledback. 

To find out the which insert statement caused this, I need to insert one by one in the SQLServer until I hit the error.

Is there clever way to findout which statement and which field caused this issue using exception handling? (SqlException)

SQLException : String or binary data would be truncated

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个C#代码，它在一个批处理中执行大量的insert语句。在执行这些语句时，我得到了“字符串或二进制数据将被截断”错误和事务角色返回。为了找出是哪条insert语句导致了这个错误，我需要在SQLServer中一个接一个地插入，直到遇到错误。有没有聪明的方法可以使用异常处理来找出哪个语句和哪个字段导致了这个问题？(S...

问SQLException :字符串或二进制数据将被截断
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQLException :字符串或二进制数据将被截断EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQLException :字符串或二进制数据将被截断
EN