I would like to copy a table all info to another table info I found this in MS site
Select * into SQLShackDemo.HumanResources.Department from AdventureWorks2012.HumanResources.Department
I haven't really tested this but surely it works fine... but anyway now I would like to copy everything from a table of database A to a table of database B. How do i do that?
And is it possible to schedule this work so it automaticly runs at end of month? How to do then?