Sandor Korozsi’s linkblog

  .NET Framework, C#, Smartphone, Pocket PC, Managed DirectX, Game development
MS SQL ServerSeptember 12, 2007 17:26

Searching a column for all words, any words, or exact phrase in a SQL Table

"Here’s one way to implement a search, similar to Google’s, if you don’t want to (or can’t) use full text indexing. This allows you to pass a string of words, and indicate that either ALL words must match, ANY must match, or the exact string must match."

It is useful to read the comments about collation errors etc.

Searching a column for all words, any words, or exact phrase in a SQL Table

Comments (0)
Tool, MS SQL ServerSeptember 7, 2007 16:18

Helen Joyce : SQL Multi Script v 1.0 - Alpha release. Just one click to run scripts on all your SQL Servers

"There’s a working application available for download FREE which allows you to execute a script (or set of scripts) against multiple servers. That’s pretty much it! It’s called SQL Multi Script and you can download the alpha version here it doesn’t require an install and you can get started in about 1 minute. Open a script or scripts or write your own on the fly Add the SQL Servers Execute on all the Servers in one go! There are amazon vouchers available for good feedback. Take a look and post a comment on the forum. It won’t take you a moment and it could save you hours!"

Helen Joyce : SQL Multi Script v 1.0 - Alpha release. Just one click to run scripts on all your SQL Servers

Comments (0)