1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| drop table tt_sla
create table tt_sla
(ttsla_id int identity(1,1),
ttsla_text large_remarks null
)
insert tt_sla
(ttsla_text
)
select 'dfsfsdfsdfsdfsdf' + char(13) + char(10) +'dfsdfsd'
select *
from tt_sla
declare @ptrval varbinary(16)
select @ptrval = textptr(ttsla_text)
from tt_sla
select @ptrval '@ptrval'
declare @deb int,
@fin int,
@val varchar(255)
select @deb = 1,
@fin = 3,
@val = 'bonjour'
updatetext tt_sla.ttsla_text @ptrval 15 4 @val
select *
from tt_sla
READTEXT tt_sla.ttsla_text @ptrval 1 25 |
Partager