Well I've found the soloution for my prblem and I'am explaining it for other users:<br>
For reterirving the hierarchical data as mentioned above we have to create a stored procedure and then we can call it from anywhere by just giving the starting point.<br>
The procedure below require a...
Thanks for the response it really help me!<br>
<br>
One thing more(if you dont mind). <br>
By default the search is case insensitive I suppose(I've test it).<br>
Can we make it case sensitive?<br>
<br>
-Faisal
Dear freiends,<br>
I'am new to SQL Server and want to know that does SQL server supports recursive queries like ORACLE does("connect by", "prior" clauses within PL/SQL).<br>
Let's suppose i've a database which can store categories for an auction site like eBay. The table structure would be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.