Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 server property

Author  Topic 

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2008-05-24 : 05:46:20
hi,
whether there is any server property to remove lines while viewing the records in text mode

sample data:

select * from Employee
sno ename
--- ------
1 aaa
2 nnn

i need to remove the below the sno and ename column

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-24 : 07:26:10
Why do you want to do that? Didnt understand need of such a requirement?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-24 : 12:28:33
you can't.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-24 : 14:08:13
You can delete rows from table with delete statement.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-24 : 14:47:07
How???
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-24 : 20:42:13
I believe OP meant to delete rows instead of removing columns. Anyway even removing columns is doable, you don't know how?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-24 : 23:09:27
My question(according to OP) is how do you remove --- ------ while you view result in text mode????????
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-24 : 23:24:40
Yes, you can remove lines from result panel.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-25 : 01:15:39
quote:
Originally posted by rmiao

Yes, you can remove lines from result panel.


I think OP was asking is there a way by which results wont display line below column names in results tab when viewing as text.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-25 : 14:02:22
Does where clause do that?
Go to Top of Page

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2008-05-26 : 00:52:48
can u say how to remove??
quote:
Originally posted by rmiao

Yes, you can remove lines from result panel.

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-26 : 00:59:12
In query result panel, you can highlight whatever like to remove then right click on it and choose delete.
Go to Top of Page
   

- Advertisement -