SQL不会让我替换SELECT语句中的引号(SQL wont let me replace a quote in SELECT statement)
我试图从我的SQL导出中的列中删除双引号,并且在研究了正确的方法之后我得到了一个错误...这是我尝试过的方法之一....
SELECT '293453' as custnum, REPLACE(Orders.Order_Comments, '"', '') as FULFILL1, OrderDetails.OrderID as OrderID2, etc.产生的错误是:
您的SQL无效:参数数据类型文本对替换函数的参数1无效。
I am trying to remove double quotes " from a column in my SQL export and I get an error, after researching the proper way... this is one of the ways I have tried....
SELECT '293453' as custnum, REPLACE(Orders.Order_Comments, '"', '') as FULFILL1, OrderDetails.OrderID as OrderID2, etc.The resulting error is:
Your SQL is invalid: Argument data type text is invalid for argument 1 of replace function.
最满意答案
看一下这个答案: SQL Server在TEXT字段中查找和替换
text数据类型无法与replace一起replace ,因此您需要将其强制转换为VARCHAR(MAX)
REPLACE(CAST(Orders.Order_Comments AS VARCHAR(MAX)), '"', '')Take a look at this answer: SQL Server find and replace in TEXT field
The text data type is not valid for use with replace, so you need to cast it as VARCHAR(MAX)
REPLACE(CAST(Orders.Order_Comments AS VARCHAR(MAX)), '"', '')更多推荐
发布评论