Re: SET NOCOUNT ON
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Wed, 19 May 2004 09:31:48 -0700
This line supresses the statistics output of the number of affected rows
when performing a query.
--
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Reza Alirezaei" <anonymous@discussions.microsoft.com> wrote in message
news:eh32W3bPEHA.3100@TK2MSFTNGP10.phx.gbl...
> what dose this line at the beginign of an stored procedure do??
> SET NOCOUNT ON
>
>
> Thanks in advance for your time.
>
>
Relevant Pages
- Re: Website Connectivity?
... does the website just query our server? ... How do I give it a login to query the SQL Server running on the server? ... It would be a serious security breach to allow a remote website to ...
(microsoft.public.windows.server.sbs) - Re: SQL Server extremely slow
... An Access application using a SQL Server back-end via ODBC linked tables is ... it was performing well anyway, then there isn't much scope to improve it!) ... running any query involves TWO query engines: ... database and shunted across the network so that Access/Jet can execute the ...
(comp.databases.ms-access) - Re: Need help with query, please
... Need SQL Server Examples check out my website at ... "EManning" wrote in message ... Below is part of my query so far....is there a way to make it ...
(microsoft.public.sqlserver.programming) - Re: CONTAINS performance
... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
(microsoft.public.sqlserver.fulltext) - Re: Access to SQLServer GCE
... Actually, as Larry points out, the Access client does a good job of filtering only information that you need. ... If your query is bound to a report, and you open that report supplying a typical "where" for that report, then Access will NOT pull down all the records, but in most cases Access will only pull down the required records and respect your filter. ... So SQL server will respect the conditions and filtering placed into those queries, and therefore only pull down those records you require. ... The suggestion in these cases is to consider using a pass-through query since all of that summing is done before the row comes down the network pipe. ...
(comp.databases.ms-access) |
|
