Path: csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Odbc and client library/drivers Date: Thu, 20 Sep 2012 23:31:15 +0200 Organization: Erland Sommarskog Lines: 18 Message-ID: References: <94298aed-7cbb-41f8-a155-c4632fc9db35@googlegroups.com> <4486daa1-575b-4713-9ca5-f4c8654eb9c8@googlegroups.com> <3fe97e67-bae3-423e-9a1d-bdb938e48e7d@googlegroups.com> <50cb24ed-7b00-4bd1-9de3-dc00553ea2bb@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="9c1143bfab35549403b85d70ea1a57d8"; logging-data="23411"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+aVa2BTJG7AlhpPqVI/f+8" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:bfx+qN0f37IXJ5w2YkWEIux3Kio= Xref: csiph.com comp.databases.ms-sqlserver:1310 björn lundin (b.f.lundin@gmail.com) writes: > And here is a clearly a difference in opinion. > I do not see 'select *' as an error or as a problem. But most experienced people in this trade do. Maybe you will not redesign your system, but one day you may change jobs. In which case can be good to know that using "SELECT *" is something you should be restrictive with. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx