Interested to Buy Any Domain ? << Click Here >> for more details...
how insert selected column only ?
- 3 Answers
- 6405 Views
- Robert Half, I also Faced
- E-Mail Answers
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 |
What do you understand by a view? What does the with check option clause for a view do?
Explain indexes disadvantages?
How to rename an existing column with sql server management studio?
What are acid properties of transaction?
What do you mean by recursive stored procedure?
What is a transactions?
Mention the uses of stored procedures.
What does top operator do?
What is efficiency data?
What is difference between cte and view?
What is difference between getdate and sysdatetime in sql server 2008?
How check triggers in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
