Sometimes, a blog will contain information you wrote on a topic. Other times, a blog will be a posting about what others have already put together.
This post is the latter.
Recently, the opportunity arose to research how to search binary data in a database. The constraints were the document was stored in the table and it needed to work with SQL Server or Oracle. This post will, focus mostly on SQL Server.
This article shows in great detail how to setup the full-text indexing and provides great explanation as to many of the options within the syntax.
The article uses the Adventure Works database. If you need the Adventure Works database.
Then, after this was tested out, this article was found on Google type searching within a SQL Server.
And finally, some information on Google searching.
All these links were last tested: 23 Aug 2011.
No comments:
Post a Comment