Is there a difference between Select * and Select [list each col] [duplicate]

by

Generally, it’s better to be explicit, so Select col1, col2 from Table is better. The reason being that at some point, an extra column may be added to that table, and would cause unneeded data to be brought back from the query.

This isn’t a hard and fast rule though.

More Related Contents:

  1. How to store a list in a column of a database table
  2. Linq version of SQL “IN” statement
  3. How can you handle an IN sub-query with LINQ to SQL?
  4. LINQ to SQL query using “NOT IN”
  5. Linq to SQL: How do I stop the auto generated object name from being renamed?
  6. SQL Data models
  7. How to randomly select rows in SQL?
  8. What’s the difference between TRUNCATE and DELETE in SQL
  9. SQL to LINQ with multiple join, count and left join
  10. SQL best practice to deal with default sort order
  11. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  12. How can I get column names from a table in Oracle?
  13. single fixed table with multiple columns vs flexible abstract tables
  14. How can I send email from PostgreSQL trigger?
  15. How to design a database for User Defined Fields?
  16. How to delete Duplicates in MySQL table
  17. Normalization in plain English
  18. Core Data Performance with Single Parent Entity
  19. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  20. MySQL – how to front pad zip code with “0”?
  21. Oracle (Old?) Joins – A tool/script for conversion?
  22. How can I implement SQL INTERSECT and MINUS operations in MS Access
  23. Postgres Error: More than one row returned by a subquery used as an expression
  24. Does ‘Select’ always order by primary key?
  25. How do I create and query linked database servers in SQL Server?
  26. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  27. Should I commit or rollback a read transaction?
  28. Why are foreign keys more used in theory than in practice?
  29. Entity Framework Skip/Take is very slow when number to skip is big
  30. What is difference between foreign key and reference key?

Leave a Comment