Wednesday, June 14, 2017

SP2-0027: Input is too long (> 2499 characters) - line ignored problem


đŸ˜‚Question :how to solve this SP2-0027: Input is too long (> 2499 characters) - line ignored problem



Ans : Download Notepad++ software


then paste you sql block in this NotePad++ editor then do word-wrap for all sql
then goto Edit menu then Line Operations then Split Lines then you can remove word-wrap  here
Wola now can run your Any length char(more then 2499 char) sql query