Update titles Set titleid=Stuff(titleid,1,3,'ABB') Where type='business'
UPDATE titles SET titleid = replace(titleid, substring(titleid, 1, 3), 'ABB') WHERE type = 'business'; or: update titles SET titleid = replace(titleid, left(titleid,3), 'ABB') WHERE type = 'business' or: Update titles Set titleid=Stuff(titleid,1,3,'ABB') Where type='business' --没有执行.? --表里有符合条件的数据吗?
运行Select * from titles Where type='business'看看有没有数据。
--建立测试环境 Create Table titles (titleid Varchar(50), type Varchar(50)) --插入数据 Insert titles Values('dadsadsad','business') Insert titles Values('ggegr','business') Insert titles Values('eeee','AAdsad') --测试 Select * from titles Update titles Set titleid=Stuff(titleid,1,3,'ABB') Where type='business' Select * from titles --删除测试环境 Drop Table titles --结果 /* --Update前 titleid type dadsadsad business ggegr business eeee AAdsad--Update后 titleid type ABBsadsad business ABBgr business eeee AAdsad */
运行Select * from titles Where type='business'看看有没有数据。有5条符合条件的数据.我每次运行SQL SERVER都很麻烦. 因为装的是双系统,每次都得退出这个系统,再进另一个系统.
UPDATE titles SET titleid = replace(titleid, substring(titleid, 1, 3), 'ABB') WHERE type = 'business';
or:
update titles SET titleid = replace(titleid, left(titleid,3), 'ABB') WHERE type = 'business'
or:
Update titles Set titleid=Stuff(titleid,1,3,'ABB') Where type='business'
--没有执行.?
--表里有符合条件的数据吗?
--建立测试环境
Create Table titles
(titleid Varchar(50),
type Varchar(50))
--插入数据
Insert titles Values('dadsadsad','business')
Insert titles Values('ggegr','business')
Insert titles Values('eeee','AAdsad')
--测试
Select * from titles
Update titles Set titleid=Stuff(titleid,1,3,'ABB') Where type='business'
Select * from titles
--删除测试环境
Drop Table titles
--结果
/*
--Update前
titleid type
dadsadsad business
ggegr business
eeee AAdsad--Update后
titleid type
ABBsadsad business
ABBgr business
eeee AAdsad
*/
因为装的是双系统,每次都得退出这个系统,再进另一个系统.
每次运行SQL SERVER都很麻烦?你装了的那个总要作为服务器开起来吧!