Guardar archivos en sql2000

[[nlsgarcia]]

Kurono,

Revisa estos links:

1- http://www.dbforums.com/microsoft-sq...er-2000-a.html

2- http://www.databasejournal.com/featu...ver-Part-2.htm

El tipo de campo blob en SQL Server 2000 es Image.

Tomado del libro : Microsoft SQL Server 2000 Bible de Paul Nielsen, Editorial Wiley.
"SQL Server can store any binary object up to 2GB, which definitely qualifies as a binary large object (blob) in an image column"

Tomado del link 2:

"SQL BOL (Books On Line) gives a good example of the three binary types:

-Use Binary when the sizes of the column data entries are consistent (and less than 8,000 bytes).

-Use varBinary when the sizes of the column data entries vary considerably (and are less than 8,000 bytes).

-Use varBinary(max) when the column data entries exceed 8,000 bytes.

-For SQL 2000, use the Image data type. However, be aware that Microsoft has stated the Image data type is for backwards compatibility only, and may be discontinued on a future version."

Te anexo una tabla del mencionado libro que define el campo blob Image.

Espero sea útil

Nelson.