Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2011-11-22 : 10:30:34
|
| Hello,I need to query a table POSTS as follows:- Find POSTS which TITLE contains Entity AND Framework.- FIND POSTS which TITLE contains Entity OR Framework.I have a few questions, if you don't mind:1 - How can I create a query for this?2 - Can I use Full Text Search?3 - Is Full Text Search available in SQL SERVER 2008 R2 Express?4 - Can I add Full Text Search to an existing database?5 - When activating the Full Text Search what type of configuration do I need? Do I need to specify for which tables and columns? Do I need to create some indexes?Thank You,Miguel |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-22 : 10:38:11
|
| For 3 see (full text search comes under programability)http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspxYou might not need the answer to any more of the questions after that.for 2, 4 yes3 no5 depends on your system1 have a look at contains - searching for sql server contains gives lots of examples.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Contains. Full Text Search