Anyone care to post a "best practice" example use of this feature?

I bought the $25 version, and it has rough edges but saves loads of time.  It provides not just decent intellisense, but code snippets.  Just being able to type ssf[TAB]...

In golf, the correct list would be 1, 2, 3, 3, 5.  Nobody came in 4th place, but someone did come in 5th.

Please post the T-SQL example here.

This post was about HOW these work, not what they do.  Can anyone confirm that there is NO performance difference between SCOPE_IDENTITY and @@IDENTITY?

Actually, the Books Online -> Scope_Identity describes what it does, but says nothing at all about how it does it.

I would surmise that each connection has TWO global last_identity values,...

Another great reason to upgrade to Yukon, where this is allowed.

I could send some Pink Paper to Redmond, this bug shows there is a terrible shortage there.

SQLXML in SQL Server 2000 isn't suited for this task, in my opinion.  I agree with the posters above who say in SQL2000 you should do this outside of your...

WOW!

We just found out that if SQL Server 2005 is creating XML, and the column contains HTML data, it AUTOMATICALLY does the HTMLEncode() for you.

We don't need our Managed Extension,...

Thanks Chris.  Astute as always.

Our design calls for the XML data to be produced by SQL Server 2005, which it is simply great for, but there are also elements that...

First, strSource is a String, not a StringBuilder, so it is immutable.  You'd need:

strSource = strSource.Append( "something" );

But you should certianly use a StringBuilder for work like this.

If you check Kalen Delaney's Inside SQL Server 2000, Chapter 7, Corrolated Subqueries, Page 354, she explains that using the LEFT JOIN and testing for null uses less than half...

Sql Server cannot handle this, see MS article:

http://support.microsoft.com/kb/200043/EN-US/