Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by faisal
-
Recursive Queries in SQL Server!!
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...- faisal
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Searching Text fields!!
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- faisal
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Searching Text fields!!
Can anybody tell me how can we seacrh in a text field using SELECT statement.<br> <br> Thanks<br> -Faisal<br> Faisal@visualsoft-inc.com- faisal
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Recursive Queries in SQL Server!!
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...- faisal
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
