On 2016/04/19 10:48 PM, R Smith wrote: > > > On 2016/04/19 8:34 PM, Jarred Ford 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. > > No. An in-memory database has no descriptor or handle that can be > accessed externally. You can make several connections which can all > spawn in-memory databases, but you cannot attach a memory database to > another memory database in another connection. (you can of course > easily attach other file DBs to a memory DB, but that point is moot).
Correction: As others have pointed out, that answer should have read: "Yes - within the same connection". Re-reading your question, I'm not sure why I assumed you'd want to have cross-connection memory DBs, but I did. Good luck!
