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 the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Explain about local stored procedure?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
explain databases and sql server databases architecture? : Sql server database administration
How to use values from other tables in update statements in ms sql server?
How to add more data to the testing table in ms sql server?
What is relationship? What number of sorts of relationship are there?
Explain how to send email from sql database?
What are the grouping functions?
Explain the steps needed to create a scheduled job?
What are the basic functions for master, msdb, model, tempdb databases?
How to change server name in sql server?
Tell me what are the essential components of sql server service broker?
Tell me about normalization in DBMS.