Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Quick SQL 2000 Query Help Needed
10-07-2008, 11:25 PM #1
- Join Date
- Dec 2005
- Thanked 1 Time in 1 Post
Quick SQL 2000 Query Help Needed
I know this isn't really an asp.net question, but I couldn't find a proper place for this question (SQL Server questions). I figured I'd find the most seasoned MS developers here--I hope you can help.
I am using a SQL Full Text Catalog for a simple search of multiple tables on my website. I wrote a simple stored procedure that searches each table for the search text using contains(*, @searchText).
I am trying to modify one of the queries but cannot figure out the correct syntax:
SELECT c.ID, TABLENAME = 'CHAPTERS' from Chapters LEFT OUTER JOIN CASESTUDIES cs on cs.Id = c.caseId where cs.isPublished = 1 AND where contains(*, @searchText) UNION ALL
Thanks in advance! Please let me know if you need any clarification.