Rowset Functions

Transact-SQL Reference

Transact-SQL Reference

Rowset Functions

These rowset functions return an object that can be used in place of a table reference in a Transact-SQL statement.

CONTAINSTABLE

FREETEXTTABLE

OPENDATASOURCE

OPENQUERY

OPENROWSET

OPENXML

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

See Also

Functions