Re: How to tell if a stored proc included a Select statement
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 06/01/04
- Next message: nikos kantzelis: "isolation levels"
- Previous message: Tibor Karaszi: "Re: how to include database with installation files of msde"
- In reply to: Ian Tompsett: "Re: How to tell if a stored proc included a Select statement"
- Next in thread: Roji. P. Thomas: "Re: How to tell if a stored proc included a Select statement"
- Reply: Roji. P. Thomas: "Re: How to tell if a stored proc included a Select statement"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Jun 2004 08:42:03 +0100
Check @@ROWCOUNT in SQL Server 2000 Books Online, and see if that's what you
are after.
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important for a database professional? http://vyaskn.tripod.com/poll.htm "Ian Tompsett" <anonymous@discussions.microsoft.com> wrote in message news:F581C020-BBD2-42E6-B650-3AFBBF3FE550@microsoft.com... Thanks Vyas I'm hoping to call a number of stored procedures from C# (through ADO.NET) in one database call. To allow me to synchronise the result sets from the database call I would like to return as many result sets from the DB as there are stored procs called. So I would like to be able to tell in a T-sql stored proc whether another stored proc that it has called populated a result set. If it has, there's nothing more to do. If it hasn't, I'll just I'll populate a kind of empty result set that can be recognised in the C# code as one to ignore. The relevant question: if one T-sql stored proc calls another T-sql stored proc, can the calling sproc know if the called sproc populated a result set? (I hope my terminology is correct - by "result set" I mean the results of a select statement that isn't stashed away into any variables. So it will be available in the calling ADO.NET as a DataTable within a DataSet. Easiest example: "select * from someTable") Just FYI - the call into the DB from C# will be contain an XML string. This string will contain a series of elements, each containing the name of the actual sproc to call. So I want as many result sets as there were stored procs called. Thanks again Ian
- Next message: nikos kantzelis: "isolation levels"
- Previous message: Tibor Karaszi: "Re: how to include database with installation files of msde"
- In reply to: Ian Tompsett: "Re: How to tell if a stored proc included a Select statement"
- Next in thread: Roji. P. Thomas: "Re: How to tell if a stored proc included a Select statement"
- Reply: Roji. P. Thomas: "Re: How to tell if a stored proc included a Select statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
