Home > IT Answers > SQL Server > Sql Query
Mr. SEA
130 pts.
 Sql Query
SQL Server
I have save data with special character (Enter Mark) in DB. But when I query the table and copy & paste result in excel then (Enter Mark) character does not come. I have refreshed the DB server due to some technical problem. Before reset it was working properly. But not now. plz help.

Software/Hardware used:
ASKED: October 3, 2012  1:37 PM
UPDATED: October 3, 2012  6:55 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Mr. SEA   130 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

When you see the query results, is this ‘special’ character there ?
What is that special character exactly ?
What do you mean by ‘refreshed the DB server’ ?

carlosdl
 63,580 pts.
 

Actually, my data contains enter mark. (slash n). recently I had installed DB server( I have changed Server Machine). I restored data on new machine. I run the query and copy paste in excel. It was working perfectly before to change machine, but now when i paste date in excel, there is no enter mark exist.I don’t what setting i have missed to configure. However i have installed on default settings.Kindly help….

Mr. SEA
 130 pts.
 

However i have installed on default settings.
 
“Installed”? What did you install? Are you referring to a new install of SQL Server on a new system?
 
Carlosdl’s first question is most important, and it still needs to be answered.
 
Tom

TomLiotta
 110,135 pts.