Incorrect solution.

To full-text index data that is NOT "plain text" (e.g., HTML, XML, Word, PowerPoint, PDF, etc.) you have to configure the indexer to use a filter.  The available filters, with...

Jeff,

In answer to your question regarding my use case for needing to pass a table to a function here is a summarized example:

In our application individual Users or Groups (containing...

Oracle has the "CREATE OR REPLACE" syntax which I really liked.

Lacking that in SQL Server, I create each stored procedure or function as a stub.  Then the main procedure or...

This is long overdue.  I've had this functionality in Oracle for the past ten years (since Oracle 8.0)!  When Microsoft introduced the table variable, they never finished the job.

I also...

I have been doing hierarchical queries in RDBMS (Oracle, SQL Server 2000/2005, DB2) for 20+ years.

For SQL Server, there are a number of ways to do this in T-SQL.  However, the...

Only true way to look at this is to get the query plan actually run (not estimated) for the different queries and see what is different.  Along with a trace.

Since...

If you store numbers as a string, then you'll never be able to order (sort) them properly.  E.g., the numbers 1 through 10 will sort as:

1

10

2

3

4

5

6

7

8

9

However, certain items commonly having...

Use a 2 dimensional temp table, or table variable (better), having the old and new values.  Then perform an update using an inner join operation.