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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-22 : 08:38:13
|
| micha writes "Let's say a have millions of records in a local cache (a certain proprietary database from my point of view) and not in the SQL Server. But still I want to execute an SQL query on the data, at least in the context of the data, without joins to other tables. Is it possible to define a certain SQL Server table to be external, and providing a simple "get data" interface the SQL Server can use to access my data (without loading into into the database)?One simple example can be millions of files in the file system (considered as a database), when the query is getting the list of files based on certain attributes (size is below a limit, or files not accessed after a certain date and so on), or getting aggregated information (total number of files, total size of files when files are selected with condition on attributes).Thanks in advance! Micha" |
|
|
|
|
|
Using data not residing in table of SQL Server in queries