Michael Brösdorf
michael.broesdorf at web.de
Mon Jun 16 10:59:57 CDT 2003
Hi David, if NOCOUNT is set to ON the number of rows affected by each SQL Select is not returned. However, the rows are still displayed in query analyzer. I want to create a tool for the dba that checkes the consistency of several data tables. I created a table containing SQL Statements is processed by the sp and results are written to a log table. when the sp is finished, the result rows from the log table should be displayed in the result pane of the Query Analyzer. The number of tables to be checked is about 10 with several conditions for each table. It works fine so far except that the result pane contains 31 result sets, which is quite ugly... Michael -----Ursprüngliche Nachricht----- Von: dmcafee at pacbell.net [mailto:dmcafee at pacbell.net] Gesendet: Montag, 16. Juni 2003 17:45 An: michael.broesdorf at web.de Betreff: RE: [dba-SQLServer]Stored procedure question look at SET NOCOUNT = ON (and off) in BOL, I think that's what you're looking for. HTH David -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Francisco Tapia Sent: Monday, June 16, 2003 8:29 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Stored procedure question hmm, It might be helpful to see what you are doing, could you post the code? -Francisco http://rcm.netfirms.com/ On Monday, June 16, 2003 7:55 AM [GMT -8], Michael Brosdorf <michael.broesdorf at web.de> wrote: : Dear group, : : I have a stored proc that includes a whole bunch of SELECT : statements. When the sproc is executed used Query Analyzer, the : result sets of all those SELECT's is displayed. But I want only the : result set of the last SELECT to be displayed. : : Is that possible? : : : TIA, : : : Michael : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com