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.
Printable View
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);
The word INTO probably shouldn't be there.Quote:
insert into
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?