行集函数 (Transact-SQL)Rowset Functions (Transact-SQL)

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

下列行集函数将返回一个可用于代替 Transact-SQLTransact-SQL 语句中表引用的对象。The following rowset functions return an object that can be used in place of a table reference in a Transact-SQLTransact-SQL statement.

OPENDATASOURCEOPENDATASOURCE OPENJSONOPENJSON
OPENROWSETOPENROWSET OPENQUERYOPENQUERY
OPENXMLOPENXML

所有行集函数都具有不确定性。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

内置函数 (Transact-SQL)Built-in Functions (Transact-SQL)