SQSH: Producing an html result set with go -m html

1> select name, dbid from master..sysdatabases where dbid < 5 order by dbid
2> go
 name                           dbid
 ------------------------------ ------
 master                              1
 tempdb                              2
 model                               3
 sybsystemprocs                      4

(4 rows affected)
1> select name, dbid from master..sysdatabases where dbid < 5 order by dbid
2> go -m html

<table border>
<tr>
   <th>name</th>
   <th>dbid</th>
</tr>
<tr>
   <td align=left>master</td>
   <td align=right>1</td>
</tr>
<tr>
   <td align=left>tempdb</td>
   <td align=right>2</td>
</tr>
<tr>
   <td align=left>model</td>
   <td align=right>3</td>
</tr>
<tr>
   <td align=left>sybsystemprocs</td>
   <td align=right>4</td>
</tr>
</table>

<p>
(4 rows affected)
</p>
1>

Roger
Roger Hall
COMPUSPEC
Google
 
Web Compuspec.net
Valid XHTML 1.0!
Valid CSS!