Re: Retrieve file BLOB from SQL Server 'Image' field type


No such thing as a small change
	PerlMonks

by Corion (Patriarch)

on Sep 24, 2015 at 05:45 UTC ( [id://1142867]=note: print w/replies, xml )

Need Help??

                    select t.RDFILE
                    from DB_NAME.schema.TABLE_NAME t
                    where t.UNIQUEID = $uniqueId
[download]

Are you sure that the rows get returned in the order you want?

You will need an ORDER BY clause on something.

Comment on Re: Retrieve file BLOB from SQL Server 'Image' field type Select or Download Code

Replies are listed 'Best First'.
Re^2: Retrieve file BLOB from SQL Server 'Image' field type by monkey_boy (Priest) on Sep 24, 2015 at 13:21 UTC
The column names suggest a single row will be returned. This is not a Signature...	[reply]
Re^2: Retrieve file BLOB from SQL Server 'Image' field type by porg (Novice) on Sep 24, 2015 at 14:05 UTC
Hi, thanks for the reply - this will only return one result, so I would assume the info is returned in the manner i should read it.	[reply]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://1142867]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others admiring the Monastery: (3)

As of 2024-04-20 05:47 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found