i want to select a table in xml format using ado,
but i meet some problem.
how can i get the rowresult in T-sql?

Below are the codes.
Any suggestion will be appreciated.
declare @err int,@src varchar(255),@desc varchar(255)
declare @recObj int
declare @strCon varchar(1000),@strSql varchar(100)

set @strCon='Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog='
+db_name()+';Data Source='+@@servername
set @strSql='select * from xt_auto_sqxx_down for xml auto'

exec @err=sp_oacreate 'adodb.recordset',@recObj out
if @err<>0 goto lberr

exec @err=sp_oamethod @recObj,'open',null,@strSql,@strCon
if @err<>0 goto lberr