Re: What is wrong with this? : select * from (exec sp_helpdb)
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/28/04
- Next message: Andrew M: "Re: MS SQL Equivalent of MS Access FORMAT function -- HELP!"
- Previous message: Aaron Bertrand - MVP: "Re: Syntax error converting character string to datetime"
- In reply to: TomTom: "Re: What is wrong with this? : select * from (exec sp_helpdb)"
- Next in thread: TomTom: "Re: What is wrong with this? : select * from (exec sp_helpdb)"
- Reply: TomTom: "Re: What is wrong with this? : select * from (exec sp_helpdb)"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 May 2004 12:50:57 -0400
> Thank you, everyone. It looks like this is a limitation of SQL, with a lot
> of workaround.
And some good reasons, too. Stored procedures are not just used for
retrieving data. I have many stored procedures that perform a simple update
or delete statement. So if I say:
SELECT * FROM (exec SomeUpdateProc)
Should the engine try and figure out if I merely meant to execute the
statement? And if so, should it execute it, even though it knows I won't be
getting any results in my select?
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/
- Next message: Andrew M: "Re: MS SQL Equivalent of MS Access FORMAT function -- HELP!"
- Previous message: Aaron Bertrand - MVP: "Re: Syntax error converting character string to datetime"
- In reply to: TomTom: "Re: What is wrong with this? : select * from (exec sp_helpdb)"
- Next in thread: TomTom: "Re: What is wrong with this? : select * from (exec sp_helpdb)"
- Reply: TomTom: "Re: What is wrong with this? : select * from (exec sp_helpdb)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
