Same rational. If you don't need the row count, don't ask for it. Andy
-----Original Message----- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 10:46 AM To: SQL Subject: RE: set nocount on? Well, the reason I asked is because this person use it in an insert cfquery statement in ColdFusion. It is not an exec store procedures. Cfquery does not return how many rows are being affected anyway. Is there any reason why you should use it when you are not using store procedures? Johnny >http://www.google.com/search?hl=en&q=set+nocount+on&btnG=Google+Search > >-----Original Message----- >From: Johnny Le [mailto:[EMAIL PROTECTED] >Sent: Friday, April 29, 2005 8:31 AM >To: SQL >Subject: set nocount on? > > >Hi, > >What does set nocount on and off do? I saw an insert statement that starts >with SET NOCOUNT ON and end with >SELECT @@identity AS userID >SET NOCOUNT OFF > >I know what select @@identity does, but what is set nocount on and off for? > >Johnny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
