>I have this very long SQL command which is wrapped into 336 lines. While finishing it, Visual Studio starts crashing as soon as I try to add more lines. Is this a limit?
How exactly you're constructing it? Are you using StringBuilder ?
One alternative will be to use View (on inline table valued function) and another to use stored procedure.
Also in C# you can easily write long block of code with
string LongString = @"This is very long SQL
statement
it may spawn
many lines";
Unfortunately, I don't think there is VB.NET analogue for the same.
If it's not broken, fix it until it is.
My Blog