On Wed, Apr 20, 2016 at 10:22 AM, Dominique Devienne <ddevienne at gmail.com> wrote:
> 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 > Oops, forgot the file: protocol prefix. --DD > ATTACH DATABASE "file:mem1?mode=memory" as db1; > ATTACH DATABASE "file:mem2?mode=memory" as db2; > etc... --DD >
