•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 397,850 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,345 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 763 | Replies: 3 | Solved
 |
•
•
Join Date: Apr 2007
Posts: 246
Reputation: 
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
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
•
•
Join Date: Apr 2007
Posts: 246
Reputation:
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
got the answer
insert table_name1(col1,col2,...) select col1,col2,... from table_name2
insert table_name1(col1,col2,...) select col1,col2,... from table_name2
•
•
Join Date: Aug 2006
Location: India
Posts: 812
Reputation:
Rep Power: 4
Solved Threads: 13
Practically a Posting Shark
or
insert into table_name2
select col1,col2 from table_name1
insert into table_name2
select col1,col2 from table_name1
There is just two ways to live your life.
One is as though nothing is a miracle.
The other is as if everything is.
One is as though nothing is a miracle.
The other is as if everything is.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation:
Rep Power: 4
Solved Threads: 78
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.
you have to specify the column name
Your code will work if both the tabels are having same structure.
Share your Knowledge.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- Removing Query Strings (ASP.NET)
- Double MySQL Query (PHP)
- Dynamic Query (JSP)
- MySQL nested query / joined query conversion help (MySQL)
- problem with lengthy query (Java)
- Retreiving variables from a sql query into a form (PHP)
- Sql Query (VB.NET)
- Query Building (Database Design)
Other Threads in the MS SQL Forum
- Previous Thread: Updating one table from another
- Next Thread: Repeated Row In Record Sets
