Searching for text in SQL Server objects

When debugging or carrying out impact analysis, it is useful to be able to search for specific text in your SQL Server database. You may wish to see where a specific stored procedure is called from, for example. 286 more words

SQL Server

How to replace first occurrence of a word in a sentence in SQL Server

Have you ever thought of How REPLACE is working? It just replaces all the occurrences of a word in the sentence.

Lets look at an example. 250 more words

SQL Server

Extract string before a special character

Here is an easy way to get (extract) all of the characters before a special character in a string.  In our example we have a listing of email addresses and we want to get the name before the @domain. 241 more words

Hints And Tips