Rowset functions returns an object that can be used as if it were a table or a view.
All rowset functions are nondeterministic i.e They return different value every time they are called with a specific set of values.
Below are the rowset functions available in sql server.
- CONTAINSTABLE
- FREETEXTTABLE
- OPENDATASOURCE
- OPENQUERY
- OPENROWSET
- OPENXML