Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TEH721
Starting Member
3 Posts |
 Posted - 2008-05-21 : 11:29:06
|
| I moved a database from one server to another, in this database are references to a UNC path on the server. now I need to find a way to modify the server name that was in each row to reflect the new server name and path, ex:\\server1\path1\data to now say\\server2\path2\datahow do I selectivly modify just some of the data? or do I have to basically re-write the entire column for each row? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-21 : 11:34:57
|
| Use REPLACE() function. |
 |
|
|
|
|
|
Changing partial data in rows