cursor
Queries and Filtered Cursors
By Sergey - Posted on January 1st, 2008
The SELECT - SQL Command with INTO CURSOR clause can create a filtered cursor under following conditions:
- Only one table is referenced by the query
- WHERE condition is fully optimizable and can be represented by SET FILTER TO command
- In the Select list either '*' specified (all fields) or subset of the fields from the table
- No additional clauses, like DISTINCT, ORDER BY, GROUP BY, etc., are present
- SET EXACT and SET ANSI settings match
Recent comments
3 weeks 1 day ago
3 weeks 2 days ago
3 weeks 2 days ago
5 weeks 2 days ago
6 weeks 5 days ago
7 weeks 10 hours ago
8 weeks 22 hours ago
11 weeks 14 hours ago
12 weeks 5 hours ago
12 weeks 5 hours ago