UPDATE TB_Hospital SET HospitalName='xxxx',HospitalAddress='呼和浩特市回民区公园东路6号' WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院' 我想要把里面的HospitalName='xxxx', 替换成空格应该怎么写。谢谢
UPDATE TB_Hospital SET HospitalName='', HospitalAddress='呼和浩特市回民区公园东路6号' WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院' 这个试试
--1 UPDATE TB_Hospital SET HospitalName='',HospitalAddress='呼和浩特市回民区公园东路6号' WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院' --2 UPDATE TB_Hospital SET HospitalName=replace(HospitalName,'xxx','')
declare @s varchar(1000) set @s='UPDATE TB_Hospital SET HospitalName=''xxxx'',HospitalAddress=''呼和浩特市回民区公园东路6号'' WHERE 1=1 AND HospitalName=''内蒙古自治区妇幼保健院''' set @s=replace (@s,'HospitalName','@a') set @s='declare @a varchar(1);'+@s
是删除 [ "HospitalName='xxxx',"] ,要在程序中处理
string i="UPDATE TB_Hospital SET HospitalName='xxxx',HospitalAddress='呼和浩特市回民区公园东路6号' WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院'";i=substring(i,0,23)+substring(i,43,len(i)-43)这样?
sql server 会截断尾部空格
UPDATE TB_Hospital SET HospitalName=replace(HospitalName,'xxxx',' '),HospitalAddress='呼和浩特市回民区公园东路6号' WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院'
HospitalAddress='呼和浩特市回民区公园东路6号'
WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院'
不明白什么意思,是想把HospitalName设成空???
xxx:表明内部是可以任意字符串
HospitalAddress='呼和浩特市回民区公园东路6号'
WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院' 这个试试
UPDATE TB_Hospital SET HospitalName='',HospitalAddress='呼和浩特市回民区公园东路6号' WHERE 1=1 AND HospitalName='内蒙古自治区妇幼保健院'
--2
UPDATE TB_Hospital SET HospitalName=replace(HospitalName,'xxx','')
set @s='UPDATE TB_Hospital SET HospitalName=''xxxx'',HospitalAddress=''呼和浩特市回民区公园东路6号''
WHERE 1=1 AND HospitalName=''内蒙古自治区妇幼保健院'''
set @s=replace (@s,'HospitalName','@a')
set @s='declare @a varchar(1);'+@s