您当前位置：首页 > 数据库 > Sqlserver > 将截断字符串或二进制数据语句已终止

将截断字符串或二进制数据语句已终止

来源：程序员人生发布时间：2014-06-09 06:55:33 阅读次数：2581次

　　将截断字符串或二进制数据。语句已终止……　

　　我在设计数据库的时候准备在一个表中设计一个NContent字段，它的数据类型为varchar(50)，由于是在可视模式下新建的，没有太注意，也许是鼠标滑轮不小心滑动力，导致NContent字段的数据变成了：nvarchar()类型了，所以在后来的添加数据时就出现了“将截断字符串或二进制数据。语句已终止……”的错误提示。。。

　　解决办法当然有多种，一是修改数据库字段大小；二是加强数据强壮性，严格的输入判断。目前是采用修改数据的方法：alter table1 alter column caller varchar(50)

以下为引用的内容：
Server Error in '/Rainbow' Application.
--------------------------------------------------------------------------------

将截断字符串或二进制数据。语句已终止。
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 将截断字符串或二进制数据。语句已终止。

Source Error:

Line 488: myInputs.Add("InputParams" , InputParams);
Line 489: myInputs.Add("RealModuleID" , ModuleID);
Line 490: workflow.DoAction(wid, actionId, myInputs);
Line 491: #region
Line 492: #region

Source File: C:InetpubwwwrootRainbowDesktopModulesTaokeCatalogsActionsDo.ascx.cs Line: 490

Stack Trace:

[SqlException: 将截断字符串或二进制数据。
语句已终止。]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount) +43
NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Boolean[] includeProperty, Object oldVersion, Object obj, SqlString sqlUpdateString, ISessionImplementor session) +709
NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Object[] oldFields, Object oldVersion, Object obj, ISessionImplementor session) +111
NHibernate.Impl.ScheduledUpdate.Execute() +134
NHibernate.Impl.SessionImpl.ExecuteAll(IList list) +128
NHibernate.Impl.SessionImpl.Execute() +103

[ADOException: could not synchronize database state with session]
NHibernate.Impl.SessionImpl.Execute() +184
NHibernate.Impl.SessionImpl.Flush() +27
NHibernate.Transaction.AdoTransaction.Commit() +101
DotNetTools.Workflow.Spi.Hibernate.HibernateWorkflowStore.MarkFinished(IStep step, Int32 actionId, DateTime finishDate, String status, String caller) in D:WorkingWorkflowWorkflow-OldsrcDotNetTools.WorkflowSpiHibernateHibernateWorkflowStore.cs:309

[StoreException: Saving current step with action 102]
DotNetTools.Workflow.AbstractWorkflow.DoAction(Int64 id, Int32 actionId, IDictionary inputs) in D:WorkingWorkflowWorkflow-OldsrcDotNetTools.WorkflowAbstractWorkflow.cs:721
Rainbow.DesktopModules.TaokeCatalogs.Actions.Do.DirectDoWorkflowAction(String sWid, Int32 actionId, User user) in C:InetpubwwwrootRainbowDesktopModulesTaokeCatalogsActionsDo.ascx.cs:490
Rainbow.DesktopModules.TaokeCatalogs.Actions.Do.Page_Load(Object sender, EventArgs e) in C:InetpubwwwrootRainbowDesktopModulesTaokeCatalogsActionsDo.ascx.cs:79
System.Web.UI.Control.OnLoad(EventArgs e) +67
Rainbow.UI.WebControls.PortalModuleControl.OnLoad(EventArgs e) in C:InetpubwwwrootRainbowapp_codeRainbowUIWebControlsPortalModuleControl.cs:710
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.AddedControl(Control control, Int32 index) +307
System.Web.UI.ControlCollection.Add(Control child) +153
System.Web.UI.WebControls.RowControlCollection.Add(Control child) +33
DUEMETRI.UI.WebControls.DesktopPanes.CreateControlHierarchy() +1129
DUEMETRI.UI.WebControls.DesktopPanes.CreateChildControls() +27
Rainbow.UI.WebControls.DesktopPanes.CreateChildControls() in C:InetpubwwwrootRainbowapp_codeRainbowUIWebControlsDesktopPanes.cs:138
System.Web.UI.Control.EnsureChildControls() +100
System.Web.UI.Control.PreRenderRecursiveInternal() +38
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1489

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

生活不易，码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
程序员人生

------分隔线----------------------------

上一篇 随便说说adwords和ppc

下一篇 SQL Server中Convert转化函数的使用

分享到:

------分隔线----------------------------

为码而活

积分：4237

15粉丝

7关注

栏目热点

将截断字符串或二进制数据 语句已终止

将截断字符串或二进制数据语句已终止