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
Can we linked SharePoint to a SQL database?
Tell me what is de-normalization and what are some of the examples of it?
Define outer join?
Explain for xml explicit mode?
What is difference between count (*) and count column?
Does union all remove duplicates?
How to convert a unicode strings to non-unicode strings?
Do you know what is similarity and difference between truncate and delete in sql?
How to create user defined functions with parameters?
What does null mean?
What is collation sensitivity? Explain different types.
Benefits of Stored Procedures?
What are the elements of dbms?
What are the dis_advantages of stored procedures, triggers, indexes?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
