p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP.NET 2.0 and Databases (http://p2p.wrox.com/forumdisplay.php?f=276)
-   -   How to pass data from Table1 to Table2 in SQl 2005 (http://p2p.wrox.com/showthread.php?t=72960)

bex February 26th, 2009 08:28 AM

How to pass data from Table1 to Table2 in SQl 2005
 
Hi there i need to pass the data in table1 into table2 and delete the same data in table1.

i need this to happend in buttonclick event and i have to use the Where Close.

the tables have the same data type and columns
i use vb SQL 2005 and VS 2005

any help apprisiated

Imar February 27th, 2009 05:25 AM

Is this a homework assignment? (because of the "I have to use a WHERE clause"?

If so, you're better off posting here: http://p2p.wrox.com/need-help-your-homework-248/

To solve this problem, look in the Books On Line (BOL) of SQL Server for "INSERT INTO" and "DELETE"; they allow you to copy data from one table to another, and then delete the old records.

Cheers,

Imar

bex February 27th, 2009 05:55 AM

Hi Imar this is not a homework assignment,
i have posted something else this morning under Begin Aspnet 2.0 Basic, if u can have a look that will be great

thanks


All times are GMT -4. The time now is 09:06 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.