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 are “lost updates”?
what is a check constraint?
do you know how to configure db2 side of the application? : Sql server database administration
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
Distinguish between nested subquery and correlated subquery?
Characterize join and name diverse sorts of joins?
What are the types of joins in sql?
How to install sql server 2005 express edition?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
what stored procedure would you use to view lock information? : Sql server administration
What is bulkcopy in sql?
How can I know what locks are running on which resource?
what's new in sql server 2016?
Is it possible in sql table to have more than one foreign key?
How can we use ConnectorJ JDBC Driver with MS SQL?