Unanswered: Thrown in the deep end (INSERTING HTML)
This is my first post here, and I am new to SQL Server. I have just been given the task of developing a website based on SQL Server and I am trying to insert a long string of HTML (could be up to 5000 chars) into a VARCHAR field. Obviously, this means that there will be double quotes, reserved words and all sorts of tricky bits and pieces in the string, so I think I must need some kind of function for preparing such a string. I have read through the SQL Server book by Wrox press, but it doesn't mention a thing that could help. Does anyone know what needs to be done here?
Cheers for the reply. Panet Source Code seems to be down atm. One question, though. When you say 'code examples', do you mean that I will need to code an MSSQL function to prepare the string for insertion into the table? I'm using query analyser, and I was kind of hoping that there would be some built in function for preparing the string.