setcount on
-
used to display the "messages" return by running a sql statement. Experiment with it in Query Analyzer to see what it does to a basic SQL statement. Look where you want to go not where you don't want to crash. Bikers Bible
-
Hi, I hope that there is no option such as setcount on in sql, Instead we have a statement set nocount on/Off The explanation is given below which is available in SQL books online please refer the same for further explanation Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results. Syntax SET NOCOUNT { ON | OFF } Remarks When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the count is returned. The @@ROWCOUNT function is updated even when SET NOCOUNT is ON. SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. When using the utilities provided with Microsoft® SQL Server™ to execute queries, the results prevent "nn rows affected" from being displayed at the end Transact-SQL statements such as SELECT, INSERT, UPDATE, and DELETE. For stored procedures that contain several statements that do not return much actual data, this can provide a significant performance boost because network traffic is greatly reduced. The setting of SET NOCOUNT is set at execute or run time and not at parse time. Happy Programming