What errors can you spot in this SQL code?

Question

Create table 2table
(student_id number(4) primary key,
student_name char(10),
student_address varchar(100));

insert into 2table values
(12345, ‘john’, ‘washington’);

insert into 2table values (&&id, &&name,'&&address');
insert into mydata2 values (&id, &name, '&address');

Answer 1

2table is a bad name

12345 is too big

mydata2 is not defined

Either & or && is incorrect, but I have never used that syntax before

Answer 2

How To Diagnose and Correct Errors

http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx

Answer 3

You cannot start a table's name with a numeric value.

Answer 4

&&address shouldn't have apostrophes ... the DB will automatically convert whatever you fill in the parameter into varchar

Answer 5

I don't think you can have your tables start with a number (#)