View Single Post
  #1 (permalink)  
Old February 26th, 2009, 08:28 AM
bex bex is offline
Friend of Wrox
Join Date: Aug 2008
Location: london, , United Kingdom.
Posts: 154
Thanks: 7
Thanked 1 Time in 1 Post
Default 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