Interested to Buy Any Domain ? << Click Here >> for more details...
how insert selected column only ?
- 3 Answers
- 6591 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 are the parts of a function?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Difference Between varchar and nvarchar datatype?
How do indexes help, types?
What is data block and how to define data block size?
Which are ddl commands?
Do you know spatial data types - geometry and geography in sql server 2008?
How many full-text indexes can a table have?
Explain transaction server distributed transaction?
How to populate a table in sql server?
What is a covering index?
What is @@rowcount in sql?
-
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)
