How can we help you today? How can we help you today?

Exact

I have one database with a lot of tables with column name "transac".
Also I have the following table:

CREATE TABLE [dbo].[FX_ScriptTransactions](
[IdScript] [varchar](50) NOT NULL,
[Error] [int] NULL,
[IdScripts] [varchar](1000) NULL,
[Descripcion] [varchar](8000) NULL,
[Dependencias] [varchar](1000) NULL,
CONSTRAINT [PK_FX_ScriptTransactions] PRIMARY KEY CLUSTERED
(
[IdScript] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

When I try to fin string "transac" (exact), objects "tables" SQL Search also show me the above table.

What Exact means in this case?
Luis Martin
0

Comments

5 comments

Sort by
  • David Atkinson
    "Exact" does a full string match. If it is unchecked, it treats each word (separated by a space) separately. The analogy in a Google search would be to put the search term in quotes.

    So in the case where you have just one word it should make no difference.

    We're aware that the terminology is confusing. How could we improve this?

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • Luis Martin
    I'm still confused :oops:

    If I search for
    transac
    with exact checked, why I get
    FX_ScriptTransactions ?

    In that case transac is part of FX_Script.......
    Luis Martin
    0
  • David Atkinson
    I see your point. It's allowing exact searches to be substrings as well, which it probably shouldn't! We'll review this behaviour and hopefully improve what it does.

    Thanks,

    David
    David Atkinson
    0
  • CGLuttrell
    would it help to have a "whole word" option like I have seen in some search tools that would not pick up substrings?
    CGLuttrell
    0
  • Alex Fekken
    I was about to agree with the "Whole Word" suggestion, but I now realise I need to read the manual first. :?

    Apparently "Exact match" doesn't affect the "Matches on Text" results. If this is a bug then the rest of this message is probably a waste of time as everything else may be a knock-on.

    But if it is intentional then shouldn't there be a separate option for Partial vs Whole Word matches on "Matches on Text"? And wouldn't it be useful if you could restrict the "Match on" subjects if the behaviour of different Match subjects is meant to be different. There might also be a link with this issue:

    Column matches for views show the view definition while for tables they show no detail. Perhaps as a result the column matches for views show up when a partial column name is searched for, regardless of the setting of the checkbox. The fact that the "Match on Text" hits also show (always) may be related to this.


    Thanks for your efforts,
    Alex
    Alex Fekken
    0

Add comment

Please sign in to leave a comment.