Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I guess the question is, even if you were able to do this in the database, how would you handle it in the UI?</p> <p>Most likely every search result from a different table will have different attributes that need to be displayed in order for the end user to understand what it is.</p> <p>The Google search box only needs to search one thing - the content of web pages - and return one type of result - web page URLs and excerpts. Fundamentally you are trying to search for many different things, and so you'll most likely need to handle each case separately.</p> <p>Alternatively, you could maintain a denormalized search table that contains only the search text and the common attributes you think need to be displayed with each hit. Maintain it either with a scheduled task or with triggers. You'd be able to use FTS on this as well.</p> <p><strong>Update</strong></p> <p>Some of the comments express some uncertainty over what SQL Server Full-Text Search is capable of. FTS can most definitely search for a single string anywhere within the text of a column, and can do other things as well (proximity search, free-text search, etc.) If you're just getting started then I'd recommend the <a href="http://technet.microsoft.com/en-us/library/ms142571.aspx" rel="nofollow noreferrer">TechNet</a> pages on the subject, the documentation is very comprehensive.</p> <p>In particular I'd suggest having a look at the section on <a href="http://technet.microsoft.com/en-us/library/cc879299.aspx" rel="nofollow noreferrer">Configuring Catalogs</a> and the <a href="http://technet.microsoft.com/en-us/library/ms142497.aspx" rel="nofollow noreferrer">Getting Started</a> page (Cole's Notes: you have to create catalogs - writing <code>CONTAINS</code> queries without them won't get you very far). Then take a look at the <a href="http://technet.microsoft.com/en-us/library/ms142559.aspx" rel="nofollow noreferrer">querying</a> page. I'd be very surprised if you can't find answers to any and all of your questions there.</p> <p>If you still can't get it to work, I would post a new question with the specifics of your problem - what you've tried, what you're expecting, and what's happening instead.</p>
    singulars
    1. This table or related slice is empty.
    1. POBest Way To Partial Search in SQL 2008
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAaronaught
    1. USAaronaught
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI see what you're saying, and after thinking about it I realize I'm wasting the user's time if I search for things they're not interested in example: the user types in "0008" which to them is a partial site code, but I wouldn't know the difference and I could find serial numbers, reference numbers, etc I figure I could have a dynamic list of options they can search for, and that's fine. But what I found is that FTS wouldn't help me with a partial search. if the user wants to show All the codes that contain "VM000" in codes like (CMVM0001, CMVM0002, CMVM0003) I want to let them do that
      singulars
      1. PO
      1. USDan
    2. CO@Dan: I confess to not being sure exactly what you mean when you say that FTS can't do a partial search as per your example. Isn't that exactly what the `CONTAINS` and `FREETEXT` keywords do?
      singulars
      1. PO
      1. USAaronaught
    3. COLooking at this: http://en.wikipedia.org/wiki/SQL_Server_Full_Text_Search and from my research, FTS can only do "Prefix Term Searches" and not search in the middle of words.
      singulars
      1. PO
      1. USDan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload