Using INSERT / OUTPUT in a SQL Server Transaction

Frequently I find myself in situations where I need to insert records into a table in a set-based operation wrapped inside of a transaction where secondarily, and within the same transaction, I spawn-off subsequent inserts into related tables where I need to pass-in key values that were the outcome of the initial INSERT command. Thanks to a Transact/SQL enhancement in SQL Server, this just became much easier and can be done in a single statement... WITHOUT A TRIGGER!

Subtle Line Feed / Carriage Return issue

Queries for SSC Community Participation

Bill Nicolich uses T-SQL to look at the community participation of people at SQLServerCentral.

Sequence

SELECT TOP

NULL Values and Joins

T-sql

New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string

Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_parser can be also very powerful for debugging purposes. It can help you check how the word breaker and stemmer works for a given input for Full Text Search.

T-SQL Tuesday #13 Roundup

Steve Jones summarizes the posts from this month's blog party.

Nested Temporary Tables