rowset-functions-transact-sql.md

title	Rowset Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	sql-database
ms.service
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	functions [SQL Server], rowsets rowsets [SQL Server], functions rowsets [SQL Server]
ms.assetid	ac24d700-3144-4ab5-9fa8-8c014001cc71
caps.latest.revision	24
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	On Demand

Rowset Functions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

The following rowset functions return an object that can be used in place of a table reference in a [!INCLUDEtsql] statement.

OPENDATASOURCE	OPENJSON
OPENROWSET	OPENQUERY
OPENXML

All rowset functions are nondeterministic. This means these functions do not always return the same results every time they are called, even with the same set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

See Also

Built-in Functions (Transact-SQL)