insert into

I am following the online course on this site example. I am seem to stuck on the insert into section.

keep getting the error check sql statement. any help appriecate.

Welcome to the site;)

I'd be helpful if you posted the info you're trying to insert.

insert into
myemployees_tj111
(firstname, lastname, title, age, salary)
values ('Jonie','Weber','Secretary',28,19500.00);


please check sql statement

Are you missing any non-null columns?

I am following the instruction how to insert into table

I am totatlly new to sql

creat table myemployees_01
(firstname,lastname,title,age,salary);

then

insert into
myemployees_01
(firstname,lastname,title,age,salary)
values('john','smith','programmer',28,5800.00);

Quote:

---

insert into

---

The word INTO probably shouldn't be there.

Insert into is valid in sql server:
USE AdventureWorks2008R2;
GO
INSERT INTO Production.UnitMeasure
VALUES (N'FT', N'Feet', '20080414');
GO

myallsql_01, cab you post error message here? You didn't specify data type for column when create table?

Quote:

---

Originally Posted by myallsql_01

creat table myemployees_01
(firstname,lastname,title,age,salary);

then

insert into
myemployees_01
(firstname,lastname,title,age,salary)
values('john','smith','programmer',28,5800.00);

---

Try it without the ; semi colons AND be sure and spell CREATE correctly.