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.reviewer
ms.technology	t-sql
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
author	MashaMSFT
ms.author	mathoma
manager	craigg

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)