Queries and Cursors

Will queries internal having one or more subquery result in cursors at SQL Server level.

In otherwords I am not explicitly using cursors but i have query with a sub query. Now for processing this query will SQL server create cursors internally.

Answers


No sql server do not create any cursotr the subquery. go trough the below link for more details

There are two kinds of subqueries: standard and correlated. The standard subquery executes once, and its results are fed into the parent query. A correlated subquery executes once for every row retrieved by the parent query. In this tip, I shed some light on the power of nested subqueries (I'll save correlated subqueries for another day).

Subquery Fundamentals

Working with nested subqueries in SQL Server


Need Your Help

Getting multiple entries from extra lazy loaded collection

performance hibernate jpa lazy-loading

Is it possible to somehow get multiple objects from a one-to-many-collection by index/key, which is marked with extra lazy load?

Why is this C program segfaulting at this location?

c segmentation-fault

I'm working on making a C program that basically can take a sentence and count how many times each word appears in it. I've made a stripped down version that reproduces the issue exactly.