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
thanxAssuming there are no identity keys:
INSERT INTO table2
SELECT * FROM table1
Converting problem