SQLExamp: Determining Column Widths
SQLExamp illustrates handling of various data types for consistent output. The example processes a user's Transact-SQL statement and formats result rowset data for display.
Default Location
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\DBLib\SQLExamp
Functions Illustrated
| Dbinit | dbnextrow |
| Dbsettime | dbnumcols |
| Dbmsghandle | dbcoltype |
| Dberrhandle | dbcolinfo |
| Dblogin | dbcollen |
| DBSETLUSER | dbcolname |
| DBSETLHOST | dbdata |
| DBSETLVERSION | dbdatlen |
| Dbopen | dbconvert |
| Dbcmd | dbcancel |
| Dbsqlexec | DBCOUNT |
| Dbresults | dbclose |