On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich <jay at kreibi.ch> wrote: > > On Apr 19, 2016, at 1:34 PM, Jarred Ford <jroddrof at hotmail.com> wrote: > > > Is it possible to create multiple in-memory databases and be able to > access tables with a single query between them? > > For example, select * from db1.dbo.table1 db1 join db2.dbo.table1 db2 on > db1.x = db2.x. > > Sure. Like any other database, you?ll need to open the additional > databases using the ATTACH DATABASE command. Just open an in-memory > database first, then run: > > ATTACH DATABASE ?:memory:? AS db2 >
To attach several memory DBs, it's more like ATTACH DATABASE "mem1?mode=memory" as db1; ATTACH DATABASE "mem2?mode=memory" as db2; etc... --DD
