如何用单引号替换sqlserver中的字符串 [英] How to replace string in sqlserver with single quotes
本文介绍了如何用单引号替换sqlserver中的字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有价值员工有
申报emp varchar(10)
set emp ='harsh,suresh,mohan'
select * form Emp其中名称(emp)
我尝试过的方法:
声明emp varchar(10)
设置emp ='harsh,suresh,mohan'
select * form Emp where name in(replace(emp,',','',''))
解决方案
你可以不要直接做。请参阅此处:在SQL IN子句中使用逗号分隔值参数字符串 [ ^ ]
声明@emp VARCHAR(10)
set @ emp ='harsh,suresh,mohan'
select @emp
SELECT REPLACE(@emp,',','','')
声明@emp VARCHAR (100)
set @ emp ='harsh,suresh,mohan'
select @emp
SELECT REPLACE(@emp,',','')
i have values Employee has
Declare emp varchar(10)
set emp ='harsh,suresh, mohan'
select * form Emp where name in (emp)
What I have tried:
Declare emp varchar(10)
set emp ='harsh,suresh, mohan'
select * form Emp where name in (replace(emp, ',','',''))
解决方案
You can't do it directly. See here: Using comma separated value parameter strings in SQL IN clauses[^]
declare @emp VARCHAR(10)
set @emp= 'harsh,suresh,mohan'
select @emp
SELECT REPLACE(@emp, ',','','')
declare @emp VARCHAR(100) set @emp= 'harsh,suresh,mohan' select @emp SELECT REPLACE(@emp, ',',' ')
这篇关于如何用单引号替换sqlserver中的字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文