ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
how insert selected column only ?
 Question Submitted By :: Sri
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how insert selected column only ?
Answer
# 1		 
insert into <table_name> (<col1>,<col3>)
values(<val1, val3)
 
Is This Answer Correct ?    4 Yes 0 No
Manoj
 
  Re: how insert selected column only ?
Answer
# 2		 
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 ?    2 Yes 1 No
Rajkumar
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are constraints? Explain different types of constraints?  6
how to know description of a table in sqlserver 2000  7
What is mean by "fill factor" ? and what is mean by "Index "in sql? Logica-CMG1
Can we create clustered index on non primary key column CTS14
Explain the basic concepts of SQL server architecture?  2
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan? HCL2
Where do you think the users names and passwords will be stored in sql server?  3
Is it possible to delete duplicate rows in a table without using a temporary table ?  6
what is the difference between Delete and Truncate Geo-Research-Centre3
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  4
Which stored procedure will you be running to add a linked server?  1
What is RAID and what are different types of RAID configurations? Wipro5
What types of integrity are enforced by a foreign-key constraint  1
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.  1
What are the type of Indexes? which one is best, why?  5
How to find the date and time of last updated table? Teledata4
How do you use DBCC statements to monitor various aspects of a SQL server installation?  1
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?  1
Can you give an example of Stored Procedure?  2
what is the Enterprise manager(2000) and management studio (2005)?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com