General information
Forum:
Microsoft SQL Server
Hello,
I'm trying to get data out if an image field that was text. I can get the binary information then manually use the convert line to get the text...
Here is what I have:
CREATE PROCEDURE GetChunkData
@bodyID uniqueidentifier,
@chunkindex int,
@chunksize int
AS
BEGIN
-- Find and retrieve chunk data from chunk table
-- returns the first 256 bytes of the field
DECLARE @val binary(16)
SELECT @val = TEXTPTR(chunkdata) FROM relaystorebodychunks where bodyid = @bodyID order by chunkid
READTEXT relaystorebodychunks.chunkdata @val @chunkindex @chunksize
--SELECT CONVERT(varchar(8000), !!covert the READTEXT line!!)
END
GO
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only