rowset-functions-transact-sql.md

title	Rowset Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
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	BYHAM
ms.author	rickbyh
manager	jhubbard

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)