This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
integration:rdbms:sqlserver:queries [2011/04/07 17:54] 127.0.0.1 external edit |
integration:rdbms:sqlserver:queries [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 26: | Line 26: | ||
Other queries will require access to the underlying SQL Server data. The Omnidex SQL Engine will determine how to combine the results from the Omnidex indexes with the data from the SQL Server database. Usually, this requires that Omnidex provide SQL Server rowids or primary keys and request rows from the SQL Server tables based on those values. Other times, Omnidex may issue a more complex statement to SQL Server, asking it to perform a larger role in processing the query. | Other queries will require access to the underlying SQL Server data. The Omnidex SQL Engine will determine how to combine the results from the Omnidex indexes with the data from the SQL Server database. Usually, this requires that Omnidex provide SQL Server rowids or primary keys and request rows from the SQL Server tables based on those values. Other times, Omnidex may issue a more complex statement to SQL Server, asking it to perform a larger role in processing the query. | ||
- | In all cases, Omnidex will access the data in the SQL Server database using standard SQL Server SQL statements issued using the SQL Server OBDC Connector. | + | In all cases, Omnidex will access the data using standard SQL statements issued to the SQL Server libraries. |
=== SQL Server-specific Syntax === | === SQL Server-specific Syntax === |