[program-l] ADO.NET/T-SQL: Giving a result set a name
- From: "Ian Sharpe" <isforums@xxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Sep 2005 09:28:55 +0100
Hi All,
Can anyone please tell me if there is a way of giving a result set returned
by an SQL Server 2000 stored procedure a name that I can use to refer to it
in a DataSet? I sometimes use a single stored procedure to return multiple
result sets and in the past have referred to each result set in the DataSet
created by it's indexed position. Each result set is given a default table
nae and so I thought that it should be possible to simply add an AS clause
to my result set in the same way as one would do when naming a table in a
subquery to specify the result set name in my DataSet. No joy though. SQL
Server gives me an incorrect syntax error near keyword AS. So I'm guessing
that this syntax is used only for subquery.
Can anyone give me a yes and if so how or a simple no you can't please?
Cheers
Ian
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
- » [program-l] ADO.NET/T-SQL: Giving a result set a name