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

Search SQL History by whole word

Does anyone know how I can get SQL History to search by the whole word?

For example, if I'm searching for usp_GetAccountSearchResults it'll show me anything beginning with usp, where the words “get”, “account”, “search” or “results” appear in the query. This is not what I want, I want to be able to search for all the queries containing exactly that term. How do I do that?

Simon Collis
0

Comments

2 comments

  • Ben Patel
    Official comment

    Hi Simon, to search the literal string enclose the search term in double quotations.

    Ben Patel
  • graded

    Hey Ben,

     I’ve run into similar issues before, so I appreciate the clarification. Simon, definitely give that a try, it should help narrow down your results to exactly what you’re looking for!

    graded
    0

Add comment

Please sign in to leave a comment.