insert statement

Question

Post reply

insert statement

neelubawa33

SSC Enthusiast

Points: 116
More actions
February 2, 2012 at 1:15 pm

#250841

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

a WHERE statement is only valid with a SELECT,UPDATE or DELETE command.

you can insert with either values, or a select statement.

insert into tbTasks_New( AssignedToId)

values('Employee')

--OR

insert into tbTasks_New( AssignedToId)

SELECT

Employee

FROM YOURTABLE

where

Owner = 'Seema'

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

johnitech.itech Hall of Fame Points: 3252 More actions · Answer 2

Ok For more Details Show

http://www.databasejournal.com/features/mssql/article.php/3507171/Transferring-Data-from-One-Table-to-Another.htm

And

http://www.w3schools.com/SQL/sql_insert.asp

😎