Topic: Changeover of a part of the text
Good afternoon. Prompt to the beginner:
1) as in lines of a field name (varchar255) tables to replace a text part ' the Russian Federation ' on ' Russia'
2) if in lines of a field name_full (varchar255) contains a text part ' the test ' to appropriate value 1
3) as in management studio 2012 to open the table that it was possible to edit some values manually?