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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2253 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
