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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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 
i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..

i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used..
 Question Submitted By :: Jerryjoseph
I also faced this Question!!     Rank Answer Posted By  
 
  Re: i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
Answer
# 1		 
dear u can do like 

insert into t2 select * from t1
insert into t3 select * from t2
.
.
.
.
so on
 
Is This Answer Correct ?    0 Yes 0 No
Gaurav
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the purpose of using COLLATE in a query?  1
How to find the last update record in SQL Server?  1
what is replication? where do u use Go Keyword? Satyam1
Write a query to delete duplicate records in SQL SERVER Infosys16
Which is best Subquery (or) joins in sql server? explain why  1
difference between sql server2000 and sql server2005  1
What is a trigger?  6
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  1
write the query for find the top 2 highest salary in sql server TCS17
What's the maximum size of a row?  4
What should we do to copy the tables, schema and views from one SQL Server to another?  3
can we call functions from stored procedure in SQL Server 2005 ? How?  2
Can I remove the default constraint columns in SQL SERVER? Value-Labs2
What is the difference Between Sql-server 2000 & 2005 Value-Labs1
What are functions  3
How do we get current date in SQL Server 2000, Oracle, MS Access?  10
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa6
Difference between server.transfer and server.execute method?  1
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000  10
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  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