asked on I need a sql script or c# code to update a column in a table
Hello
I am using a program that stores pathes to some data on a column called pathes in a table called storage.
This program was storing it's data in c: and all the rows contain something like "c:\program files\thesoftware\storage\
Now my c: is getting full, so I moved the data to "e:\thesoftware\storage\da
how can I change all the rows in the table to let it point to the files in "e:" instead of "c:\program files"
i.e. "c:\program files\thesoftware\storage\
I need an sql script or some c# code.
Thank you
I am using a program that stores pathes to some data on a column called pathes in a table called storage.
This program was storing it's data in c: and all the rows contain something like "c:\program files\thesoftware\storage\
Now my c: is getting full, so I moved the data to "e:\thesoftware\storage\da
how can I change all the rows in the table to let it point to the files in "e:" instead of "c:\program files"
i.e. "c:\program files\thesoftware\storage\
I need an sql script or some c# code.
Thank you
.NET ProgrammingMicrosoft SQL Server 2005
Last Comment
rthriller
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok, I noticed that the column content is always less than 255 chars so I converted it to varchar(MAX), ran the query above and reconvert it back to ntext and it worked! :)
Msg 8116, Niveau 16, État 1, Ligne 1
Argument data type ntext is invalid for argument 1 of replace function.