SQL SERVER的TEXT/IMAG数据类型应用(100分)

L

lyf998

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-10-28

• #1

sql server中提供了TEXT/IMAG的数据类型，但如何将文件夹中的图片文件存入IMAG类型的表列中，请举例说明，万分感激。

 

C

cAkk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-10-28

• #2

loadfromfile

 

C

cytown

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-10-28

• #3

if u want to store bitmap file in image type field , it's ok, but if
u want to store jpeg, gif, png, tiff... , i suggest u store in text
type field.
the sample is <a href="http://www.gislab.ecnu.edu.cn/delphibbs/dispq.asp?LID=146002">here</a>!

 

面

面条

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-10-28

• #4

建一个IMAGE型的字段“image1"
(Table1.fieldbyname.('image1') as TBlobField).loadfromfile(filename)
(Table1.fieldbyname.('image1') as TBlobField).savetofile(filename)

 

L

lyf998

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-10-31

• #5

我刚刚学SQL SERVER，所以请面条先生说的再细一点。