insert into Database1.dbo.Table1 select (AllCOl except identity Col) from Database2.dbo.Table2
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip
Post your Blog