|
|
Posted by Erland Sommarskog on 10/21/09 11:33
Ray Allison (ray.allison@tiscali.co.uk) writes:
> Is it bad practice to use 'Select * ' from a security perspective?
I can't see that security is much of an issue. The reason that SELECT *
is bad, is that it creates a maintenance problem. What happens if columns
are dropped, added or reordered? How can we see whether a column is
actually used?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
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
Navigation:
[Reply to this message]
|