Showing posts with label table2in. Show all posts
Showing posts with label table2in. Show all posts

Thursday, March 8, 2012

Copy Data from table1 to table2

i have tow table same structure
how i can copy the data in table1 to table2
in T-SQL statment

thanxAssuming there are no identity keys:

INSERT INTO table2
SELECT * FROM table1