Hiii DELETE T1 OUTPUT DELETED.COLUMN1,DELETED.COLUMN2... INTO T2 D

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 Posted / madhu sudhan g

4 Answers
7562 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

Please Help Members By Posting Answers For Below Questions

Why variables called the most powerful component of ssis?

1027

What is the use of sql profiler in sql server 2012?

843

What is order of B+tree?

1063

What is the maximum number of index per table?

1017

What is the function of inner join?

1005

What is the difference between a check constraint and a rule?

1135

What is the difference between DataRow.Delete() and DataRow.Remove()?

1168

What are various aggregate functions that are available?

918

How to create function with parameter in sql server?

1041

What is normalization of database?

1021

Explain different types of locks in sql server.

1013

What is the datatype of rowid?

877

What are trace files?

896

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

911

What is optimistic concurrency?

982