S. Isaac Dealey wrote: > i'm not sure if that's thread-safe tho... I don't remember offhand > what set nocount does... but the @@identity variable is from any table > in any sql server session across the database or possibly the server,
no, that's an urban myth. it's any table with a column that has an identity characteristic that you insert data into in your current session, not the db, not the server & certainly nobody else's session. scope_identity is mainly used when you have triggers & such that can change the @@identiy var value before you get at it. SET NOCOUNT ON/OFF tells sql server to return/not return metadata about how many rows were affected by the last sq statement. is often used to shave some time off stuff & was used w/4.5 & cf5 to pack more than 1 sql server statement into a cfquery. sql server returning row counts would confuse cf as if it were legitimate results. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
