惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

F
Fortinet All Blogs
WordPress大学
WordPress大学
The Cloudflare Blog
云风的 BLOG
云风的 BLOG
博客园 - Franky
D
Docker
小众软件
小众软件
阮一峰的网络日志
阮一峰的网络日志
H
Hackread – Cybersecurity News, Data Breaches, AI and More
Engineering at Meta
Engineering at Meta
MongoDB | Blog
MongoDB | Blog
U
Unit 42
M
MIT News - Artificial intelligence
B
Blog
GbyAI
GbyAI
C
Check Point Blog
P
Proofpoint News Feed
博客园 - 司徒正美
Hugging Face - Blog
Hugging Face - Blog
雷峰网
雷峰网
IT之家
IT之家
Google DeepMind News
Google DeepMind News
V
V2EX
Stack Overflow Blog
Stack Overflow Blog

博客园 - Sady

Start my new level SCM Chart How to read the contents of a remote web page rs.open syntax Get random records How to debug a vb dll for asp SQL Value Example ASP Class javascript injection attack - Sady 封装ASP Version 3 of OA System The relation chart of Supply Chain Management Version 2 of our oa system Supply Chain Management on Website Away for so long Self-promotion CSharp中几个关键概念 类的继承 DTD
Deal with replacing a string in an NTEXT field
Sady · 2010-01-11 · via 博客园 - Sady

UPDATE testTable
SET testNtext = REPLACE(CAST(testNtext AS NVARCHAR(1000)),' ',' ')
WHERE testNtext LIKE '% %'

posted on 2010-01-11 12:38  Sady  阅读(135)  评论(0)    收藏  举报

刷新页面返回顶部