sqlteam.com
More Trees & Hierarchies in SQL - SQLTeam.com
http://www.sqlteam.com/article/more-trees-hierarchies-in-sql
All Articles by Tag. More Trees and Hierarchies in SQL. On 1 May 2002. Hierarchies are sometimes difficult to store in SQL tables.things like trees, threaded forums, org charts and the like.and it's usually even harder to retrieve the hierarchy once you do store it. Here's a method that's easy to understand and maintain, and gives you the full hierarchy (or any piece of it) very quickly and easily. The table would look like this:. David St. Hubbins. And the org chart/indented list looks like this:. SELEC...
sqlteam.com
SQL Server Newsletter at SQLTeam.com
http://www.sqlteam.com/newsletter.aspx
All Articles by Tag. The SQLTeam.com newsletter goes out weekly. You can sign up on the right side of the site. Each newsletter has an unsubscribe link at the bottom and process those immediately. You can also subscribe and unsubscribe through your forum profile page. This is what youll find in a typical newsletter:. Notes on anything interesting that happened during the week such as a service pack release or product announcement. New SQLTeam.com articles. A few previous newsletters are listed below.
sqlteam.com
Using DDL Triggers in SQL Server 2005 to Capture Schema Changes - SQLTeam.com
http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes
All Articles by Tag. Using DDL Triggers in SQL Server 2005 to Capture Schema Changes. On 13 August 2007. This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced. This is where you are lucky. I think I found a way for you, the DBA, psuedo-DBA, forced DBA, etc to get the same type of change log system with just a little setup. FYI, Those rotisseries rock! DROP XML S...
sqlteam.com
Implementing a Dynamic WHERE Clause - SQLTeam.com
http://www.sqlteam.com/article/implementing-a-dynamic-where-clause
All Articles by Tag. Implementing a Dynamic WHERE Clause. On 14 January 2001. Passed on another article to us. This one covers building a dynamic where clause. And the really neat part is that you don't actually need to write dynamic SQL. This is soooo much simpler. Let's look at an example that shows how this works. Assume you have a table called Customers created with the following statement. A more efficient approach to creating dynamic WHERE clauses involves using the COALESCE function. This func...
scoble.weblogs.com
scoble_blogroll
http://scoble.weblogs.com/stories/2004/12/15/scobleblogroll.html
My Favorite Community Resources about Microsoft:. Microsoft Employee Blogs (Dev/Geek style). Microsoft Employee Blogs (IT Pro style). Activehead's .NET blogs. O'Reilly's Windows Dev Center. Top 100 Feed Sites:. My cell phone: 425-205-1921. Are you with the press? 5/11/2005; 1:44:59 AM. Be the first to comment! Free real-time blog alerts via MSN Messenger, mobile, or email.
sqlteam.com
SQL Server Forums
http://www.sqlteam.com/forums
All Articles by Tag. Please start any new threads on our new site at http:/ forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums. We've restricted the ability to create new threads on these forums. And get your question answered! General SQL Server Forums. New to SQL Server Programming. New to SQL Server Administration. Database Design and Application Architecture. SQL Server 2012 Forums. SQL Server Administration (2012).
sqlteam.com
SQL Server Forums
http://www.sqlteam.com/forums/password.asp
All Articles by Tag. Please start any new threads on our new site at http:/ forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums. We've restricted the ability to create new threads on these forums. And get your question answered! This is a 3 step process:. Enter your e-mail address in the form below to receive an e-mail containing a code to verify that you are who you say you are. Choose your new password.
lucaswyrschbroking.blogspot.com
Willkommen bei Lucas Wyrsch Broking!: Mai 2005
http://lucaswyrschbroking.blogspot.com/2005_05_01_archive.html
Willkommen bei Lucas Wyrsch Broking! Technologie-, Wirtschafts- und Strategieberatung mit Fokus auf die Finanz Dienstleistungsindustrie. Erarbeiten von globalen Konzepten in mulitkulturellen und mehrsprachigen Umfeldern von der Idee bis zur Ausführung. Durchführen von aktuariellen Analysen und Projekten im Bereich Basel II mit Schwerpunkt auf operationelle Risiken! Dienstag, Mai 24, 2005. Wie sicher ist Ackermanns Posten bei der Deutschen Bank? Druck auf Deutsche-Bank-Chef Ackermann. Wies am Samstag einen.
sqlteam.com
SQL Server Version - SQLTeam.com
http://www.sqlteam.com/article/sql-server-versions
All Articles by Tag. On 29 January 2009. I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article. SQL Server 2008 R2. SQL Server 2008 R2 CU2. SQL Server 2008 R2 CU1. SQL Server 2008 SP1.
sqlteam.com
Handling SQL Server Errors - SQLTeam.com
http://www.sqlteam.com/article/handling-sql-server-errors
All Articles by Tag. Handling SQL Server Errors. On 5 April 2010. SQL Server 2008 Features. This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions. SQL Server uses the following syntax to capture errors in Transact-SQL statements:. First] = 1 SELECT. Second] = 1/0 SELECT. Third] = 3 END. The complete text of the err...
SOCIAL ENGAGEMENT