Re: Copy table column names from SSMS Object Browser to use in a query
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 6 Nov 2007 22:29:34 +0000 (UTC)
iano (IanONet@xxxxxxxxx) writes:
I thought I saw this done once before. So today I hunted around in
Books OnLine and did a Google search. So far I have found nothing
close. So if you know how to do it, please tell me or if cannot be
done, I'd appreciate know that too.
Find the table in Object Explorer and expand the note. Select Columns
and drag it to the place where you want it.
My own take on this is that I simply run a SELECT * with TOP 1 or
WHERE 1 = 0 in text mode. I copy and paste into window in Textpad
where I have a macro that replaces the multiple spaces with comma +
space. Sounds kludgy? Well, navigating in an explorer tree takes time too.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prev by Date: Re: Copy table column names from SSMS Object Browser to use in a query
- Next by Date: Re: CASE count wierd join needed maybe? just one more field needed!
- Previous by thread: Re: Copy table column names from SSMS Object Browser to use in a query
- Next by thread: How do I pass a parameter to a DTS ?
- Index(es):
Relevant Pages
|
