I Am trying to insert into a tables using XML, But i get a error because the value of one of the xml elements has a single quote ( < tablename notes = " 2000.00 rec'd from......" /> ) how do i negate the single quote.
Double it, SQL will interpret two successive ' ('') as a single quote and store the single quote but will not generate an error.
Brainbench MVP for Visual Basic
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…