因下载站更换了域名,我需要在数据库中把旧域名http://www.123.com替换成http://www.456.com
数据库:datadown
表:downaddress
字段:downfilename
我用如下替换命令总是显示"(所影响的行数为 0 行)"不能替换成功.use datadown
go
update downaddress
set downfilename='http://www.456.com' where DownFileName='http://www.123.com'
数据库:datadown
表:downaddress
字段:downfilename
我用如下替换命令总是显示"(所影响的行数为 0 行)"不能替换成功.use datadown
go
update downaddress
set downfilename='http://www.456.com' where DownFileName='http://www.123.com'
(downfilename nvarchar(200))
insert #downaddress select 'http://www.123.com'update #downaddress
set downfilename='http://www.456.com'
where DownFileName='http://www.123.com'
select * from #downaddressdownfilename
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
http://www.456.com(1 行受影响)可以啊
go
update downaddress
set downfilename=replace(downfilename,'http://www.123.com','http://www.456.com')
select * from downaddress where DownFileName like '%123%'
(downfilename nvarchar(200))
insert #downaddress select 'http://www.123.com/dsdsd/dsdsd'update #downaddress
set downfilename=replace(downfilename,'http://www.123.com','http://www.456.com')
select * from #downaddressdownfilename
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
http://www.456.com/dsdsd/dsdsd(1 行受影响)
数据库中已存在名为 '#downaddresss' 的对象。