Tuesday, August 18, 2015

T-SQL Replace Every Occurrence of Specific Text in a Column with Other Text

This syntax can be used to replace any instance of a word or string of some specific text that appears anywhere in a column (in any row) with some other text. 

To make a global change to column "Comment":

update MyTable set Comment = replace (Comment ,'all instances','any instance'

This selective edit came in very handy the other day.

Thursday, February 19, 2015

remove entry from run command

Open up regedit.exe through the start menu run box, and then navigate down to the following key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU