Creating a Html content file from sql server

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008

Hi,

I am trying to create a html file from sql server using following method--

exec master..xp_cmdshell 'echo plaintText <path>' it is working for plaint text but when i am inserting html page source it is not working.

Any help on this would be very much appreciable.

Thanks

Posted 10-Jun-13 7:25am

Ariana Bond

Add a Solution

Comments

Ariana Bond 10-Jun-13 14:00pm

Question is down voted ,very well, but without any good reason ??

Richard C Bishop 10-Jun-13 14:36pm

I did not down vote, but I have an idea why someone would. Go to this link and read through it and you might figure out why.

http://www.codeproject.com/Articles/64628/Code-Project-Quick-Answers-FAQ

Ariana Bond 10-Jun-13 14:46pm

Hey, Ric thanks a lot man, this information meant a lot to me.
Thanks again.
Keep me updated with it if there are any sort of modification made over there. By the way thanks again.
You can see how many time i am thanking you.
You are really an expert.

Richard C Bishop 10-Jun-13 14:59pm

Not an expert by any accounts, but you will be more successful at getting good help here if you follow the guidelines.

Ariana Bond 10-Jun-13 15:06pm

if people like you and SA will help me and i will for sure appreciate SA , are here for guidelines then i would be able to learn in real manner.
I misbehaved with him last time after that i apologized but the real thing is after offence there is no place for sorry. So i'l keep in mind not to misbehave with anyone.
SA has great caliber and yours too and that's why you persons are also much more mature then me.
By the way that thanks was not joke , i mean it so you should accept it.don't you think so but the way i said it looks funny so its OK , some other time.

Richard C Bishop 10-Jun-13 15:12pm

Thank you for the kind words. You will do just fine here, just keep and open mind and don't take offense to criticism, as it is more often then not, constructive.

Ariana Bond 10-Jun-13 15:14pm

Thanks again for the help you all have done already and expect that will do in future.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jun-13 14:18pm

Do you see any error?

Ariana Bond 10-Jun-13 14:31pm

Yes there is but , may be i am completely wrong, error has nothing to do with it . Error msg displays Rollback Transaction do not has corresponding Begin transaction.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jun-13 14:38pm

So, you don't have Begin or Rollback Transactions in the query, right?

Ariana Bond 10-Jun-13 14:40pm

Absolutely wrong, I have begin transaction else script should not have parsed earlier for plain text and other thing is , i have cross checked twice after i see this error.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jun-13 14:45pm

If you have Begin Transaction, then why it is saying you don't have?

Ariana Bond 10-Jun-13 14:58pm

I am sorry but i have begin transaction.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Jun-13 15:02pm

Ok. No problem. Then do one thing now.
Paste the whole script here in your post by clicking on "Improve question" link.

Ariana Bond 10-Jun-13 15:10pm

ok

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)