Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

SQL
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
Posted

1 solution

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
 
Share this answer
 
Comments
chetna2810 28-Apr-14 8:41am    
I amd facing the same problem and my column input are not incorrect form.. :(

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900