[thelist] stored proc

Ken Schaefer ken at adOpenStatic.com
Fri Aug 6 22:51:47 CDT 2004


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Brian Cummiskey" <Brian at hondaswap.com>
Subject: Re: [thelist] stored proc


: Ken Schaefer wrote:
: Put
: SET NOCOUNT ON
:
:
: ya know, i've been using SP's for about a year now, and they all have
: this in it, but i have no idea what it does.
: care to explain?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

There is a great explanation in SQL Server Books Online

Start -> Programs -> Microsoft SQL Server -> Books Online -> Index Tab ->
SET NOCOUNT entry. Read the two topics that are there.

If you do not have Books Online installed, then you can download it from
here (or use the MSDN link to browse online):
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Cheers
Ken



More information about the thelist mailing list