我收到类似“以...开头的标识符太长"的错误.最大长度为128英寸当我尝试执行此存储过程时 [英] I am getting an error like "The identifier that starts with...is too long. Maximum length is 128" when I try to execute this Stored procedure

问题描述

当我尝试执行此存储过程时，出现类似以...开头的标识符太长.最大长度为128"之类的错误.请帮助

I am getting an error like "The identifier that starts with...is too long. Maximum length is 128" when I try to execute this Stored procedure. Pls Help

exec FC_SchoolContact_Search "main.FirstName LIKE 'School%' AND
 main.CountryCode = 'FR' AND main.StatusCode = 'AC' AND main.Contact_id Not In
(Select BookingSchool_id From Booking wb Where wb.ProductCode = 'SCH' And
 BookingSchool_id  = main.Contact_id) ","bc.ProductCode = 'SCH'",null,null,null

推荐答案

这意味着您要插入的值太大，无法达到列类型的大小.例如，您的表具有列 id 和 name ，其中name为varchar(10)，然后输入20个字符.

问候，
爱德华

This means that the value you are inserting is too large to the size of the column type. For ex, your table has column id and name wherein name is varchar(10) then you input 20 characters.

Regards,
Eduard

这篇关于我收到类似“以...开头的标识符太长"的错误.最大长度为128英寸当我尝试执行此存储过程时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！