Oh thanx that was very helpful

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...

Well on that case you need to have an else statement


IF @rc IS NULL
BEGIN
--SET @rc = 0
INSERT INTO Method VALUES (@Method, @Mdescript)
SELECT @@IDENTITY
END
ELSE

Primary key violation usually means that U are trying to enter or insert a value that already exist in the primary key field, there is nothing wrong I see in the code, Primary keys have to be unique

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...

I have 2 related tables, master and a child, the master table have a primary which is an autonumber and I reference that autonumber to my child table as a foreign key so my problem is to get the...

Guys

I need to upload an image on SQL server 2000, I dont want a C# or VB code for that I just wana know if it is possible to just upload a picture straight to SQL server without the insert...