Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rumon007
Starting Member
1 Post |
 Posted - 2010-12-28 : 02:02:34
|
1. how to migrate data from one database to another2. is it possible to migrate between two dates fro example of last 2 months any |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-28 : 05:07:15
|
insert database2.dbo.table1(column1, column2, ...)select column1, column2, ... from database1.dbo.table1where datecolumn > dateadd(month,-2,getdate())
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Data Migration