Quote In Sql String
Sql Include Apostrophe In String
Just as I posted my reply, I noted you signature that indicates that you are directly related to SC Orchestrator yourself.That changes the answer. No, not the part that it should never be done, but it makes sense to say what you submit to SQL Server. This is wrong: DECLARE @table TABLE (Column1 nvarchar( max))DECLARE @test nvarchar( max)SET @test= 'Text with single quotes like ' ' or double quotes ' or even an & or%.
Skyrim tank follower mod. This blog/website is a personal blog/website and all articles, postings and opinions contained herein are my own. The contents of this blog/website are not intended to defame, purge or humiliate anyone should they decide to act upon or reuse any information provided by me. Comments left by any independent reader are the sole responsibility of that person. Should you identify any content that is harmful, malicious, sensitive or unnecessary, please contact me via email (imran@raresql.com) so I may rectify the problem.
Aug 03, 2011 Hello all, I am writing a script that will delete a file in a directory, then add a file with given text to that directory. My problem is in the 'given text' I need to use double quotes in the string. What happends is the code sees the inner set of double quotes and ends the string. Also, in a string quoted with double quotes, any. How can the answer be improved?