Easily display all column results when executing a query?

[nkomokov]

Is there a quick way to get the results pane to display all columns in a table instead of manually listing them off in the query?

 

[jbenson001]

Select * from <table>

 

[nkomokov]

How do I put it into code like this..

Select cast(a.Email as char(20)) as Email, 
       convert(char(8),a.FirstName,110) as FirstName,
	a.LastName,
	a.Company,
	a.Title,
	a.MiddleName,
       a.Prefix, 
       a.Country, 
       a.Accreditations 
from dbo.t_contacts a
join 
(select Email 
from dbo.t_contacts
group by Email
having count(*) > 1) b  
on a.Email = b.Email
order by a.Email

 

[druer]

select * from dbo.t_contacts a
join
(rest of your code)

I'm not sure why you were doing the case in the first select for the email and for the first name, but "select *" isn't going to do the converts/casts if you really needed them.

 

[nkomokov]

Thanks! You're right, I didn't need it.

Cleaned up my code is this...

Select 	a.Email,
a.*
from dbo.t_contacts a
join 
(select Email 
from dbo.t_contacts
group by Email
having count(*) > 1) b  
on a.Email = b.Email
order by a.Email