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
How is table type constraint applied to a table?
System variable and temporary variables
Can you please explain the difference between function and stored procedure?
What is intellisense?
What is cdc in sql server?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is query optimizer in sql server?
How to rebuild all indexes on a single table?
Do you know clustered and non-clustered index?
How to start sql server browser service?
what is raid and what are different types of raid configurations? : Sql server database administration
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Can sql servers linked to other servers?
What is the default sql server instance name?
What is difference between views and tables?