Faves for this Web page
- adam - Oct 05 2006 | sql server, database, microsoft, @@identity, programming
good explanation of @@IDENTITY vs SCOPE_IDENTITY()... I never knew the difference. Also, there are 9 other things you should watch out for. (lots of common sense)
Quoted: Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value (primary key) that was entered by your active session, but in different scenarios they can each ...
10 Things You Shouldn't Do with SQL Server
Add a Fave for this Web page
- What happens when I press Publish?
- Your Fave for this Web page gets shared with the Faves community. You can access it at any time by selecting "My Faves" from the menu above.
- Why do you ask for my email address?
- We use your email address to create an account, so you can easily find your Fave again at a later time.
Related Content from Around Faves
sql server
-
1 FaverViewed: 10 TimesQuoted: SQL Server XML View Mapper 1.0 Brief Description Microsoft® SQL Server View Mapper enables you to produce an XML View schema file that relates an ...
- adam - Jun 26 20061 FaverViewed: 74 Times
- mikkelsd - Oct 04 20069 FaversViewed: 114 Times
reports
-
Great Colbert segment on Wikipedia ended up hosing Wikipedia's elephant entries for a while.
"The truth is whatever we agree on."
2 FaversViewed: 154 TimesQuoted: In his popular The Word segment, Stephen Colbert features Wikipedia, analyzing its Truthiness value and the application of Wikiality on ALL information.
- mike - Aug 19 20081 FaverViewed: 5 Times
- social101 - May 14 20081 FaverViewed: 8 Times

Good ol' SQL Server.
haha... hath I been mocked?
Nope, I just know too many peeps who work on SQL.
They sounds like cool people :-)
Some are cooler than others. ;)
Next you were supposed to say: "With you [Adam], being the coolest"
:-)