How to update data for one column in MS SQL?

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
UPDATED: November 16, 2010  3:06 PM

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Is there a predefined set of questions stored somewhere else ?
    65,110 pointsBadges:
    report
  • Chippy088
    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
    Without more details we can't assert that it can or cannot be done.
    65,110 pointsBadges:
    report
  • Santhoshnk73
    [...] 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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following