Browse by Tags

• @@rowcount
• bookmarklet
• Books Online
• Connect
• DELETE
• MERGE
• MSDN
• nonstandard
• SQL Server 2008
• Triggers
• T-SQL
• T-SQL language extensions
• URL translation

• How to convert Books Online ms-help: links to MSDN Library http: links [bookmarklet included]

  As you know, Books Online is available in two convenient locations. It's online as part of the MSDN Library, and it's offline as a Document Explorer help collection. Topics are accessible by URIs in each, but the URIs don't match. For example: Books Online Read More... Posted Wednesday, August 05, 2009 12:11 AM by skass | 5 Comments Filed under: bookmarklet, Books Online, MSDN, URL translation

• DELETE FROM Where?

  For years, SQL Server has supported a (second) FROM clause in UPDATE and DELETE statements. Its behavior isn't always deterministic, a fact Microsoft points out in the documentation. Today, someone was surprised by the basic semantics of DELETE .. FROM. Read More... Posted Thursday, April 30, 2009 6:48 PM by skass | 11 Comments Filed under: Connect, DELETE, nonstandard, T-SQL, T-SQL language extensions

• It's 2008, and @@ROWCOUNT ain't what it used to be. Don't use it in triggers.

  During SQL Server 2008 beta testing, Aaron Bertrand noted that the value of @@rowcount inside a trigger could be unexpected, if the triggering statement was MERGE. The consequences of this can be pretty bad, but fortunately there's a simple workaround. You need to do something if anyone might invoke MERGE against tables with triggers that contain @@rowcount checks Read More... Posted Wednesday, April 29, 2009 1:57 AM by skass | 5 Comments Filed under: @@rowcount, MERGE, SQL Server 2008, Triggers