how insert selected column only ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinivas
insert into <table_name> ( <col1> ,<col3>) values ( val1,val2)
Is This Answer Correct ? | 1 Yes | 0 No |
Which command is used for user defined error messages?
Explain partitioned view?
how to overcome kernel isssues
Benefits of Stored Procedures?
what is difference between having and where clause ?
What is data source view or dsv? : sql server analysis services, ssas
Why functions are used in sql server?
What are the different authentication modes in sql server? How can it be changed?
How to end a stored procedure properly in ms sql server?
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
What is the maximum length of an alert name?
What is the use of MOVE keyword in restore command