Interested to Buy Any Domain ? << Click Here >> for more details...
how insert selected column only ?
- 3 Answers
- 6724 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 is the syntax for encrypting a column in SQL Server?
What are the parts of a function?
What is history table in sql server?
How ssrs maintain security?
What is raiseerror? What is raiseerror?
What causes index fragmentation?
How do indexes help, types?
How to Insert multiple rows with a single insert statement?
What is public role in sql server?
Explain user defined views?
What is sparse columns of sql server 2008?
What are dml triggers and types of dml triggers?
-
Oracle (3253) - 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)
