Sql Query

130 pts.
Tags:
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.

Answer Wiki

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

Discuss This Question: 3  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
    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' ?
    70,220 pointsBadges:
    report
  • Mr. SEA
    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....
    130 pointsBadges:
    report
  • TomLiotta
    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
    125,585 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