----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 2 in Discussion Hi Vandhana, Me again ... Well these Oracle specific features are not present in SQL Server. The implementation of the same are specific to this database engine and archietecture ... Hence no hard feelings ... But the good news is that there are papers written on various Tree structures to be implemented on SQL Server ... Here are some of the links ... Well the one by Celko is the one I love a lot ... Trees and nesting of SPs: http://groups.google.com/groups?selm=OIWi6QB6CHA.2416%40TK2MSFTNGP09.phx.gbl Trees in SQL http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html Versatile High Performance Hierarchies in SQL Server http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm http://www.intelligententerprise.com/001020/celko.shtml http://www.dbazine.com/tropashko4.html http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B248915 http://tinyurl.com/c17l http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm HTH, Vinod Kumar SCT Software Solutions ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
