shown_sunny
May 10th, 2004, 09:14 AM
dear friends,
The following query displays the result of one record in an XML format .
=============================
select top 1 * from login for xml auto
=============================
My Question is
How to get the result of every fields without using * in a stored procedure ie., the result of this query should be stored in a single variable in the stored procedure.
regards shown sunny
The following query displays the result of one record in an XML format .
=============================
select top 1 * from login for xml auto
=============================
My Question is
How to get the result of every fields without using * in a stored procedure ie., the result of this query should be stored in a single variable in the stored procedure.
regards shown sunny