Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Selecting multipe fields from Enterprise Manager SQL

Posted on 2012-09-19
Medium Priority
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:Aleks
LVL 13

Accepted Solution

LIONKING earned 2000 total points
ID: 38414505

SELECT yourTable.*
FROM ....

Author Closing Comment

ID: 38414538

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses

581 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