Copying Image Fields - Size Limit?

Copying Image Fields - Size Limit?

Post by YPOL » Sat, 21 Apr 2001 04:26:04


The SQL Server BOL topic "Retrieving ntext, text, or image Values" states

SELECT pr_info
FROM pub_info

Does this apply only when using an API such as ODBC or will the following

INSERT INTO someTable (doc) SELECT doc FROM anotherTable

Where doc is of type Image.

I want to copy image fields between tables, the images may be several
megabytes in size.