SQL Server uses writetext to store large data volumes

 

Alter procedure awf_insertzjdata
@ Zjid varchar (11 ),
@ Fabh varchar (15 ),
@ Zhymch varchar (8 ),
@ Zjnr text
As

Declare @ error integer
Begin Tran mytran
Set @ error = 0

Delete zjdata
Where zjid = @ zjid and fabh = @ fabh and zhymch = @ zhymch
Set @ error = @ error + @ Error

Insert into zjdata (zjid, fabh, zhymch, zjnr)
Values (@ zjid, @ fabh, @ zhymch ,'')
Set @ error = @ error + @ Error

Declare @ ptrval binary (16)
Select @ ptrval = textptr (zjnr) from zjdata
Where zjid = @ zjid and fabh = @ fabh and zhymch = @ zhymch

Writetext zjdata. zjnr @ ptrval @ zjnr
Set @ error = @ error + @ Error

If @ error <> 0
Rollback Tran mysave
Commit Tran mytran