var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Connect By Clause
We have "Connect By Clause" as in Oracle. Do we have the same or equivalent in MS-SQL Server 2000?
Thanks with Regards.
Can you give some explaination about "Connect By Clause" in Oracle?
There is no connect by equivalent in SQL 2000. It has been promised for SQL Yukon.
Connect by is a way of selecting a hierarchy of records from a table. If you have a table like
You can select a manager, and all of his sub-employees (and their sub-employees, and so on..) by using a connect by query.
It's an iterative process in sql server...
you need a loop..and you need to determine how many levels you need to go...