27,579
社区成员
发帖
与我相关
我的任务
分享
UPDATE TABLE1 SET CONTENT=STUFF(CONTENT,ABS(CHECKSUM(NEWID()))%LEN(CONTENT)+1,0,'22')
update test_1 set Content=STUFF(Content,cast(ceiling(RAND(CHECKSUM(NEWID()))*LEN(content))as int),0,'22')
--USE stuff(col,pos,0,'22')
--because
select STUFF('abcd',2,0,'22') -------- a22bcd
--so
create table test_1
(
id int,
[Content] nvarchar(4000)
)
insert test_1 select
1,'bbbbbb' union select
2,'dddddd'
go
update test_1
set Content=STUFF(Content,cast(ceiling(RAND(CHECKSUM(NEWID()))*LEN(content))as int),0,'22')
go
select * from test_1
DECLARE @T TABLE([ID] INT, [Content] nvarchar(4000))
INSERT INTO @T
SELECT '1','bbbbbbbb' UNION ALL
SELECT '2','dddddddd'
DECLARE @i FLOAT
SELECT @i = RAND()
SELECT id,
SUBSTRING([content],0,CONVERT(INT,RIGHT(CONVERT(VARCHAR,@i),1)))
+'22'
+SUBSTRING([content],CONVERT(INT,RIGHT(CONVERT(VARCHAR,@i),1))+2,LEN([content]))
FROM @T
UPDATE TABLE1 SET CONTENT=STUFF(CONTENT,ABS(CHECKSUM(NEWID))%LEN(CONTENT)+1,0,'22')