Generating a result set in Adaptive Server

The following SQL script invokes the constructor of the ResultSetXml class in a server environment:

declare @rsx xml.resultset.ResultSetXml
select @rsx = new xml.resultset.ResultSetXml
 	(“select 1 as ‘a’, 2 as ‘b’, 3 ”, “none”, “yes”, “”);
insert into resultset_docs values (“1”, @rsx)