Copying Image Fields - Size Limit?

Copying Image Fields - Size Limit?

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



Hello,

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

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.

Thanks