|
|
 |
BOOK: Beginning ASP.NET 2.0 and Databases  | This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 and Databases by John Kauffman, Bradley Millington; ISBN: 9780471781349 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning ASP.NET 2.0 and Databases section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
February 26th, 2009, 08:28 AM
|
|
Friend of Wrox
|
|
Join Date: Aug 2008
Location: london, , United Kingdom.
Posts: 153
Thanks: 7
Thanked 1 Time in 1 Post
|
|
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
__________________
bx
|
February 27th, 2009, 05:25 AM
|
 |
Wrox Author
Points: 33,554, Level: 80 |
|
|
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 10,228
Thanks: 7
Thanked 203 Times in 201 Posts
|
|
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 |
February 27th, 2009, 05:55 AM
|
|
Friend of Wrox
|
|
Join Date: Aug 2008
Location: london, , United Kingdom.
Posts: 153
Thanks: 7
Thanked 1 Time in 1 Post
|
|
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
__________________
bx
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
