Hi, I have a stored procedure that creates and executes SQL insert statements using dynamic SQL. This procedure worked fine until today. The length of the insert statement exceeded 8000 characters and it seems like the varchar datatype cannot hold more than 8000 characters.
Anyone knows an easy workaround?
Can I use another datatype, that allows more than 8000 characters?
I hope I don't have to redesign my programs, just because sometimes the query gets too long.
My database is SQL Server 7.