Point out the wrong statement :
A. The Depth column comes in handy for performing the indent by using the Space() function
B. Stored prcoedures is easiest way to extract hierarchial data.
C. Inside SQL Server 2008, Microsoft introduces a new data type Index on HierarchyID to handle such type of data and reduce the complexity
D. None of the mentioned
Answer:A
Point out the wrong statement :
A. The Depth column comes in handy for performing the indent by using the Space() function B. Stored prcoedures is easiest way to extract hierarchial data. C. Inside SQL Server 2008, Microsoft introduces a new data type Index on HierarchyID to handle such type of data and reduce the complexity D. None of the mentioned
Explanation:Common Table Expressions can be a great way to extract hierarchial data.