Is there a maximum length (limit) for a SQL statement?
I Tried to Execute a Query as follows
INSERT INTO <sample table=""> (name,description) VALUES('xxxx','description text')
here i have given the description text having character of 2000000.
While executing the SQL statement via my C# code is Throws an Exception "SystemOutofMemory".
Can anyone help me or Explain me what could be the cast of it please.
and the description column is VARCHAR(MAX) allows NULL.
Thanks in Advance.