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
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.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)