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

No comments:

Post a Comment