SQL Server find and replace specific word in all rows of specific column
In this example am gonna replace empty space with _
here is the code to do that :
UPDATE your_Table_Name
SET Column_Name = REPLACE(Column_Name, ' ', '_')
here is the code to do that :
UPDATE your_Table_Name
SET Column_Name = REPLACE(Column_Name, ' ', '_')
SQL Server find and replace specific word in all rows of specific column
Reviewed by (C#) Csharp examples
on
11:10 PM
Rating:
No comments: