weixin_42481234的博客

SQL Event

MSSQLinsert failed,JSa.replace(/[']/g,'`'); //全局替换let a = "AAAA'BBBBB 'CCCC'"let b = a.replace("'"," ") //只替换了第一个let d = a.replace(/[']/g,'`'); //全局替换console.log(b) //"AAAA BBBBB 'CCCC'"console.log(d) // "AAAA`BBBBB `CCCC`" // let requ.

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation...WHERE fieldname COLLATE DATABASE_DEFAULT = otherfieldname COLLATE DATABASE_DEFAULT