Saving Pictures/JPEGS in SQL 2000

And what programming language U use?

It does no metter what U put into Database (jpeg or any other file). And there are plenty of examples in internet (search for BLOB, which stands for Binary Large Objects, in your favorite search page)

Best Regards,
Krzemo.

Maybe this will help:

SP for inserting BLOB into table TB_Images(IdRow INT IDENTITY(1,1) PK,ImageColumn IMAGE)

CREATE PROCEDURE PR_InsertImage
@i_Image IMAGE
AS
DECLARE
@_IdRow INT
INSERT INTO TB_Images(ImageColumn)
VALUES (@i_Image)
SET @_IdRow=SCOPE_IDENTITY()
RETURN @_IdRow


Sample code -executing SP from VB.NET (FileContentByteArray must be filled with content of JPEG file):

Dim FileContentByteArray As Byte()

...
Dim cmd As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand
cmd.Connection = m_Cnn
cmd.CommandType = System.Data.CommandType.StoredProcedure
cmd.CommandText = "PR_InsertImage"
Dim par As System.Data.SqlClient.SqlParameter = New System.Data.SqlClient.SqlParameter ("@RETURN_VALUE", System.Data.SqlDbType.Int
par.Direction=System.Data.ParameterDirection.ReturnValue
cmd.Parameters.Add(par)

par= New System.Data.SqlClient.SqlParameter ("@i_Image", System.Data.SqlDbType.Image, FileContentByteArray.Length)
par.Value = FileContentByteArray
cmd.Parameters.Add(par)

cmd.ExecuteNonQuery
'// Note: In cmd.Parameters(0).Value U have IDENTITY column value of just inserted image (TB_Images(IdRow))


Hope this helps.