SQL Server Performance Forum – Threads Archive

Can Row Information show column wise ?

Hi, I’m asking to everybody a simple query. I hope anyone will provide to me a best method.
The query is given below for your review. Create table employee
(
Empname char(25)
) insert employee values (‘A’)
insert employee values (‘B’)
insert employee values (‘C’) Select *from employee Empname
A
B
C
As I like to show the data information is given below:
Empname Empname Empname
A B C Amit Kumar
Mob.: 9873812005

---

http://sqljunkies.com/WebLog/mattnunn/archive/2003/08/07/173.aspx
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>