SQSH: Producing a vertical result set with go -m vert

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 vert
name: master
dbid: 1

name: tempdb
dbid: 2

name: model
dbid: 3

name: sybsystemprocs
dbid: 4

(4 rows affected)
1>

Roger Hall COMPUSPEC

Web Compuspec.net