>The hierarchyid data type


>

I have published my article titled SQL Server 2008 – The hierarchyid data type, on SQLServerUniverse.com.

Just to let you know, the hierarchyid data type is a CLR data type introduced in SQL Server 2008, and is used for storing hierarchical data. Unlike the parent/child approach which maintains a relationship among the records, this approach maintains the level and the position within the level to keep track of the records’ hierarchy.

TSQL04001_04

So, go ahead read, please my article and let me know on your thoughts.

http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-2528130281382044&dt=1209034140899&lmt=1209034140&output=html&slotname=1055406663&correlator=1209034140453&url=file%3A%2F%2F%2FC%3A%2FUsers%2FGogulaa%2FAppData%2FLocal%2FTemp%2FWindowsLiveWriter-429641856%2F160940986D18%2Findex.htm&frm=0&cc=100&ga_vid=1790101765.1209034141&ga_sid=1209034141&ga_hid=870763395&flash=9.0.115.0&u_h=1200&u_w=1600&u_ah=1170&u_aw=1600&u_cd=32&u_tz=330&u_java=true

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s