Insert an Image in SQL

[Traicey]

Guys

I have a table with image datatype and I wana insert an image in the image field, for example

insert into dbo.Products(ProductID, ProductName, ProductPrice, ProductImage)
valeus(144, '8 Gig Lenovo memory Stick', 250.00, 'Image from C:Drive or where ever the image residing')

Thanx in advance

[Teme64]

What programming language you're using? If VB.NEt, you may try Daniweb's site search. I've answered the same or at least very similar question few times. A pretty good search phrase is "image SQL Server VB.NET" (without quotes).

[Traicey]

Im not using VB.Net or any other language but SQL Server 2000, I need to write an insert statement im quiry builder in SQL which will be inserting an image and other records in my table, Im sure there is a way to do that, I just dont wana write a code in C# neither in VB to do that, I Wana insert in straight to SQL then I can retrieve it later from SQL using C#

[Teme64]

AFAIK with SQL Server 2000 you need to use textcopy utility. Check this MS forum's thread if it helps:
using textcopy to import image file (jpg) to sql server DB in SQL Server Programming

[Traicey]

Oh thanx that was very helpful

[yassooo]

how to insert image in sql ?!!!!
the link is not work
tnx