Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nandac
Starting Member
27 Posts |
 Posted - 2008-12-10 : 15:19:31
|
| if i use isql or osql is there any option to get the output to be html compatible? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-10 : 16:16:05
|
Do you have an example?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-10 : 17:01:18
|
| if i run a select how do i get the output with the requisite html code so that when the output is opened in outlook it comes in html format.i think in oracle, this is used :set markup html on spool onspool /tmp/space_report_&1..htmli'm looking for something similar. it is basically to generate the output in html format. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-10 : 17:33:25
|
What is the source?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-11 : 09:14:57
|
| let us say i run it in windows using perl or command line and want to get the output in html ... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-11 : 09:32:37
|
What is the source? Integers only? Dates? Binary values?Strings?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-11 : 14:20:40
|
| everything - integers, strings, dates etc.if i run a select from sysprocesses how do i convert the output to be html compatible? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-12 : 01:12:10
|
You use FOR XML clause at the end of query.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
html output