Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 7762 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu sudhan g
Hiii
DELETE T1
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T2
DELETE T2
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T3
DELETE T3
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T4
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to concatenate two strings in SQL Server.
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Can two different columns be merged into single column? Show practically?
How can you find out which stored procedures are recompiling?
What is outer join in sql server joins?
What do you understand by the data quality services in sql server?
How to test values returned by a subquery with the in operator?
What are types of storage modes? : sql server analysis services, ssas
Why functions are used in sql server?
What is the difference between varchar and varchar types?
How many replicas are maintained for each SQL Azure database?
Why truncate is ddl command?
What is data source view or dsv? : sql server analysis services, ssas
What is data source object?
How to connect sql server management studio express to sql server 2005 express?
