Queries and Cursors

Question

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.

Answer 1

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