How to update data for one column in MS SQL?
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
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
RELATED QUESTIONS
- KPI Report in excel
- How to remove spaces from text lines in Visual Basic script
- Pros & cons to have a typical star schema but with only one fact value field and a thousand attribute names in one of the dimension tables?
- Store and retrieve data from SQL Server 2005 in UTF-8
- Merge two datasets in a DO loop
Answer Wiki:
You are going to need to manually go in and edit each row manually. There isn't a programmatic way to do this.
To see all answers submitted to the Answer Wiki: View Answer History.
Is there a predefined set of questions stored somewhere else ?
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.
Without more details we can’t assert that it can or cannot be done.