Query Hierarchical data Using CTE in T-SQL 2005

In response to Sam Stange's "An old and new way to query Hierarchical data", this script uses the new CTE feature of SQL Server 2005 to display the hierarchical data all at once. I have added a check to prevent infinite loop in case there is a loop in the data (actually, there is one […]

3.67 (3)

2007-04-11 (first published: )

1,376 reads

Function Based Index in T-SQL

To build function based index in SQL Server, you can use indexed view (materialized view) or using a computed column. In this script, I give an exmaple of how to use the computed column to implement a function based index on a table to search through a free formated telephone number column. The basic step […]

5 (3)

2007-04-10 (first published: )

5,616 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Making Software Decisions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Making Software Decisions

Working with the Delete Activity in Azure Data Factory

By arindamxs

Comments posted to this topic are about the item Working with the Delete Activity...

Current Symmetric Key Algorithms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Current Symmetric Key Algorithms

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers