Answer Posted / rajkumar
Format
------
Inser into <tablename> (column name) select (column name)
from <tablename> where <Condition>
Example
--------
INSERT INTO emp (empname) SELECT empname from employe WHERE
empid=5
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the use of RDBMS?
What do you mean by an execution plan? How would you view it?
What is coalesce and check constraint in sql server?
What is checkpoint in sql server?
What's the information that can be stored inside a bit column?
Difference between primary key and clustered index?
What are entities and relationships?
What do you mean by authentication modes in sql server?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is a trace frag? Where do we use it?
Why transaction is important?
How to add more data to the testing table in ms sql server?
Explain about temporary stored procedure?
What are sql server functions?
What is difference between primary key and foreign key?