Insert Statment

[Seema Bawa]

What is the wrong in this query insert into tbTasks_New( AssignedToId) values('Employee') where Owner = 'Seema'

[jschell]

1. It isn't a query 2. An insert is an insert - 'where' doesn't apply (not for the form given.) It is also possible that 'Employee' is not a valid value for 'AssignedToId'

[Chris Meech]

By Owner do you mean the schema owner of the table? I don't think I've ever seen an insert statement with a 'where' clause before. :confused:

Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

[Corporal Agarn]

As jschell said. If Owner is a column in a table an insert might be like:

INSERT INTO tbTasks_New(AssignedToId)
SELECT column1
WHERE owner = 'Seema'

If you use the value command you cannot use the where (you do not need to!)

[Dnyanesh Wahiley]

your queary is like this... insert into tbTasks_New( AssignedToId) values('Employee') where Owner = 'Seema' and your solution will be like this...! Update tbTasks_New set='Employee' where Owner='Seema' ----------------------------------- Actually u have to use update statment insted of insert statment...! and then u will get ur expected output.!

Dnyanesh Wahiley....