Palm Pre

The amazing Palm Pre; the picture says it all a QWERTY Keyboard & a 3.1" display.
More like they put all the good from a Nokia E71 and an iPhone !

The Perfect Solution for quering hierarical data

Recursive Queries Using Common Table Expressions

WITH cte_name ( column_name [,...n] )

AS

(

CTE_query_definition –- Anchor member is defined.

UNION ALL

CTE_query_definition –- Recursive member is defined referencing cte_name.

)

-- Statement using the CTE

SELECT *

FROM cte_name 

SQL Server CLR Functions

SQL Server CLR Functions is simply put, mixing SQL & .NET (Can life be any better?)

To enable CLR:

exec sp_configure 'clr enabled', 1
reconfigure

References:

How to create a SQL Server Project?

How to create and run a CLR SQL Server User-Defined Function?

How to deploy SQL Server Project Items to a SQL Server?

Example