关于ntext的批量修改这个比较总要的就是一些函数的用法

最新推荐文章于 2025-09-21 10:58:42 发布

最新推荐文章于 2025-09-21 10:58:42 发布 · 86 阅读

create table textvalue (IDtext ntext) go declare @cunt int set @cunt=1 while @cunt <200 begin insert into textvalue values(CAST(@cunt*1000.111111 as varchar(max))) end go select * from textvalue go /*select replace(cast(IDtext as varchar(100)),'.','+') from textvalue where IDtext like '%.%' --这里用点主要是有时候要修改的东西是需要限制的 */ --同时减少数据量 update textvalue set textvalue.IDtext=tabletest.IDtext from (select replace(cast(IDtext as varchar(100)),'.','+') as IDtext from textvalue where IDtext like '%.%') as tabletest where textvalue.IDtext=tabletest.IDtext and textvalue.IDtext like '%.%' go drop table textvalue go