Home All Groups Group Topic Archive Search About
Author
7 Jun 2006 7:21 PM
bill
All,

Is there any way I could ask SQL to run a "Select statmant" but not return
the result set?

Thanks in advance,

Bill

Author
7 Jun 2006 7:29 PM
Dejan Sarka
> Is there any way I could ask SQL to run a "Select statmant" but not return
> the result set?

SELECT col_list
FROM table_list
WHERE 1=0

Check also SET NOEXEC and SET PARSEONLY commands, maybe this is what you
need.

--
Dejan Sarka
Are all your drivers up to date? click for free checkup

Author
7 Jun 2006 7:32 PM
Aaron Bertrand [SQL Server MVP]
> Is there any way I could ask SQL to run a "Select statmant" but not return
> the result set?

Uh, what would be the point?

Bookmark and Share