An SQL SELECT statement can have a FOR XML clause that returns the query result as XML instead of a rowset. You can also have a stored procedure that has a SELECT statement with a FOR XML clause. FOR ...

SQL triggers, procedures, and functions are powerful tools that can help you automate or enhance database operations. They are blocks of code that run in response to certain events or conditions ...

The EXECUTE statement sends dynamic non-query, DBMS-specific SQL statements to the DBMS and processes those statements. In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly ...