how to write a query to insert a row that is deleted from one table to another table using sql server 2000 at the same time
greeny_1984
14
Posting Whiz
Recommended Answers
Jump to Postor
insert into table_name2
select col1,col2 from table_name1
All 3 Replies
greeny_1984
14
Posting Whiz
got the answer
insert table_name1(col1,col2,...) select col1,col2,... from table_name2
arjunsasidharan
297
Practically a Posting Shark
or
insert into table_name2
select col1,col2 from table_name1
debasisdas
580
Posting Genius
Featured Poster
what if the the table2 contains more/different columns than the table1 ?
you have to specify the column name
Your code will work if both the tabels are having same structure.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.