Wednesday, November 12, 2003
TSQL Tidbit

Here's some info straight from the horse's mouth (SqlTeam.com).  It seems using @@Identity is potentially bad.  They say to use scope_identity() instead. See for yourself.

I'm not a TSQL guru, but I know several people using TSQL in the mojority of their products, and I've seen @@Identity in their code.

posted on Wednesday, November 12, 2003 5:52:08 PM (Pacific Standard Time, UTC-08:00)  #    Comments [1]
Related posts:
LinqToStdf now on CodePlex
Image Slicer for Deep Zoom in Silverlight 2
Silverlight limitations and Constrained Callvirt in IL
What are the generic Delegates in the framework for?
What is System.__Canon and why is it on my stack?
Adding support for .ashx-based views in ASP.net MVC
 Tracked by:
"buy cheap diet pill online" (buy cheap diet pill online) [Trackback]
"progesterone blood test" (progesterone blood test) [Trackback]
"Avg Antivirus System" (Avg Antivirus System) [Trackback]
"Duralgesic Patch and Ativan" (Duralgesic Patch and Ativan) [Trackback]
"patio furniture cushions" (patio furniture cushions) [Trackback]
"low iron" (low iron) [Trackback]
"building your own thickness sander" (building your own thickness sander) [Trackback]
"Charity Hospital New Orleans" (Charity Hospital New Orleans) [Trackback]
"car brunette blowjob" (car brunette blowjob) [Trackback]
"peter rabbit bedding" (peter rabbit bedding) [Trackback]
"what are the benefits for a structured settlement" (what are the benefits for a... [Trackback]
"landscape architecture college courses" (landscape architecture college courses... [Trackback]
"pin curlers" (pin curlers) [Trackback]
"california limousine service san francisco area" (california limousine service ... [Trackback]
"mens cufflinks" (mens cufflinks) [Trackback]
"girl leg brace" (girl leg brace) [Trackback]
"Pug Puppies for Sale" (Pug Puppies for Sale) [Trackback]
"wilton maine" (wilton maine) [Trackback]
"Navigator Electric Trolling Motors" (Navigator Electric Trolling Motors) [Trackback]
"Laura Ashley Discontinued Bedding" (Laura Ashley Discontinued Bedding) [Trackback]
"accounting information" (accounting information) [Trackback]
"Taux De Change Dollar" (Taux De Change Dollar) [Trackback]
"Computer Police Scanner" (Computer Police Scanner) [Trackback]
"DC MILL MOTORS" (DC MILL MOTORS) [Trackback]
"Funny Birthday Poems" (Funny Birthday Poems) [Trackback]
"march madness soccer tournament" (march madness soccer tournament) [Trackback]
"hp photosmart 325" (hp photosmart 325) [Trackback]
"what is lisinopril hct" (what is lisinopril hct) [Trackback]
"100 Free Ebooks" (100 Free Ebooks) [Trackback]
"Free Software to View JPG Files" (Free Software to View JPG Files) [Trackback]
"inks lake" (inks lake) [Trackback]
"how to get oxycodone" (how to get oxycodone) [Trackback]
"delphi automotive mexico manufacturing facilities" (delphi automotive mexico ma... [Trackback]
"Clarion Shutters" (Clarion Shutters) [Trackback]
Monday, January 12, 2004 3:31:05 PM (Pacific Standard Time, UTC-08:00)
Found the blog entry. And updated my stored procedures. Thanks!
Pete
Name
E-mail
(will show your gravatar icon)
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):

Page rendered at Wednesday, October 08, 2008 12:06:05 AM (Pacific Standard Time, UTC-08:00)