Here’s what I’m looking for.
Back in the day when I was using a UNIX based database (Sybase to be exact) and all my queries were done entriely on the command line within a Telnet style window it was often helpful to change the way query results were displayed.
There was a command, not sure if it was a T-SQL command or if it was a UNIX command but when you’d run a query like this:
SELECT * from user_table WHERE username = 'Omniscient'
…instead of getting the typical results that looked like this:
username member_type posts coolness wit ---------- -------------- ----- -------- ------ Omniscient Charter Member 8571 Super Rapier
You’d get results that looked like this:
username: Omniscient member_type: Charter Member posts: 8571 coolness: Super wit: Rapier
Can anyone tell me how that’s done? I’m using SQL Server 7.0 in Windows these days, and the queries are submitted using the Query Analyzer and that’s where I want to accoplish this today. Ideas? If its different in SQL Server than it was using Sybase, just for the sake of my curiosity how’d I used to do that too?