Selecting multipe fields from Enterprise Manager SQL

Posted on 2012-09-19
Last Modified: 2012-09-19
I have  a query with some joins and I only want to select ALL fields from one of the tables in my 'select' statement, if I do:

Select * from ... bla bla it will include all the fields from all tables, the alternative is to type the name of each field and there are like 40 fields in the table, is there a way to quickly select the names of all fields in that one table ?

I am using SQL 2008 Enterprise Manager.
Question by:amucinobluedot
    LVL 13

    Accepted Solution


    SELECT yourTable.*
    FROM ....

    Author Closing Comment


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now