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
7693 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

Can we add our custom code in ssis?

972

What is resultset concur_updatable?

1005

What is BCP? When does it used in sql server 2012?

1043

Explain the disadvantages/limitation of the cursor?

941

Can I delete event logs?

913

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1929

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

960

What are the advantages of user-defined functions over stored procedures in sql server?

1016

How can we call UDF(User Define Function) using C# code in ASP.net ?

6862

what is normalization? : Sql server database administration

1070

What are the Advantages of using CTE in sql server?

1095

How to retrieve error messages using mssql_get_last_message()?

1031

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1036

Call by value and call by reference in procedure and function, with NOCOPY.

1283

What are the different types of normalization?

1138