How to update data for one column in MS SQL?

Santhoshnk73

5 pts.

Tags:

SQL

SQL Database

SQL Server

SQL tables

Hi,

I have a table column named "Question" that stores the question without space.For example "Who are you" is stored as "whoareyou".Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already existing thousands of records to store the question with space.How can I do this?Any sugggestions really appreciated.

Software/Hardware used:
MSSQL

Asked: November 12, 2010 3:50 AM Last updated: November 16, 2010 3:06 PM

Answer Wiki

Last updated: November 15, 2010 12:49 PM GMT

Denny Cherry68,390 pts.
History
Contributors
- Ordered by most recent
- Denny Cherry68,390 pts.

Thanks. We'll let you know when a new response is added.

You are going to need to manually go in and edit each row manually. There isn’t a programmatic way to do this.

Discuss This Question: 4 Replies

carlosdl Nov 12, 2010 2:39 PM GMT

Is there a predefined set of questions stored somewhere else ?

84,495 pointsBadges:

report
Chippy088 Nov 16, 2010 2:29 PM GMT

I don't quite understand why the question would be stored without spaces, how do you display the question with the spaces to make it readable? Maybe you could use this function to redirect the text displayed.

4,625 pointsBadges:

report
carlosdl Nov 16, 2010 3:06 PM GMT

Without more details we can't assert that it can or cannot be done.

84,495 pointsBadges:

report
The Most-Watched IT Questions: November 23, 2010 - ITKE Community Blog Nov 23, 2010 6:44 AM GMT

[...] 5. Mr. Denny, Carlosdl and Chippy088 gave their two cents to a member wondering how to update data for one column in SQL. [...]

0 pointsBadges:

report