Conversion failed when converting the varchar value 'products 2' to data type int.

Question

1.00/5 (1 vote)

See more:

Hello, I need help with the question below. I wrote the script but it is giving me an error. There are three tables

Users:(UserId,EmailAddress, FirstName, LastName)
Products:(ProductId, ProductName)
Downloads:(DownloadID,UserID,DownloadDate,FileName,ProductID)

Add three rows to the Downloads table: one row for user 1 and product 2; one for user 2 and product 1; and one for user 2 and product 2. Use the GETDATE function to insert the current date and time into the DownloadDate column.

Thank you

What I have tried:

The script I wrote is as follows:

Insert into Downloads (UserId, ProductID, DownloadDate)
VALUES
('1',Products 2),GETDATE()),
('2',Products 1,GETDATE()),
('2',Products 2,GETDATE());

But I am getting the following error:
sg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'Products 2' to data type int.

How can I correct this?

Thank you

Posted 3-Aug-18 17:05pm

Member 13937439

Updated 3-Aug-18 18:32pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-08-03T18:32:00

Simple: "Products 2" is not a integer! (Plus, there is a spurious close bracket in there) Even as a string, it would need to be a quoted value:

SQL

INSERT INTO Downloads (UserId, ProductID, DownloadDate) 
VALUES
   ('1', 'Products 2',GETDATE()),
   ('2', 'Products 1',GETDATE()),
   ('2', 'Products 2',GETDATE());

But ... what datatype is ProductID, in both the Products and Downloads tables - they need to be the same, and the inference from the error message is that at least one of them is an INT while you are passing a VARCHAR (or NVARCHAR) value.

I'd have a close look at your table definitions and check what types you are trying to use: the quoted UserID kinda implies that's a string as well and it probably should be an integer, and not quoted in the INSERT statement.

Santosh kumar Pithani · Answer 2 · 2018-08-03T18:31:00

Solution 1

SQL

--String values must be under single quotations('Products2') but not integers.
--IF your DownloadDate column datatype is varchar then use convert(Varchar(20),GETDATE(),101) 
Insert into Downloads (UserId, ProductID, DownloadDate) 

                                  VALUES
                                      (1,'Products2',GETDATE()),
                                      (2,'Products1',GETDATE()),
                                      (2,'Products2',GETDATE());

Posted 3-Aug-18 18:31pm

Santosh kumar Pithani

Comments

Member 13937439 4-Aug-18 14:25pm

@Santosh,
The solution you provided did not work. It gave me the same error message. In the DownloadS Table, the order of columns is as follows:
DownloadID
UserID
DownloadDate
Filename
ProductID

My DownloadDate Column datatype is DateTime, NOT NULL. I hope this helps.

Thank you

Santosh kumar Pithani 6-Aug-18 0:14am

Hello, i already mentioned you that integer datatype doesn't allows string values.if your using varchar or char datatypes then make sure its length i.e varchar(500),char(50).