The Artima Developer Community
Sponsored Link

.NET Buzz Forum
Replacing SELECT * with Column Names in SQL Server

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Franco Martinig

Posts: 4004
Nickname: martinig
Registered: Apr, 2003

Scrum Expert
Replacing SELECT * with Column Names in SQL Server Posted: Jan 29, 2013 4:50 PM
Reply to this message Reply

This post originated from an RSS feed registered with .NET Buzz by Franco Martinig.
Original Post: Replacing SELECT * with Column Names in SQL Server
Feed Title: .NET Videos & Tutorial Directory
Feed URL: http://www.dotnet-tv.com/feed/
Feed Description: .NET Tutorials and Videos: C#, ASP, SQL Server, Linq, Visual Basic, Silverlight, Azure, Visual Studio
Latest .NET Buzz Posts
Latest .NET Buzz Posts by Franco Martinig
Latest Posts From .NET Videos & Tutorial Directory

Advertisement
There are many disadvantages to the usage of the SELECT * in a SQL Server query. This video explains how users can avoid using SELECT * but instead list the column names. Video source: http://blog.sqlauthority.com/2012/06/06/sql-server-tricks-to-replace-select-with-column-names-sql-in-sixty-seconds-017-video/

Read: Replacing SELECT * with Column Names in SQL Server

Topic: Async in C# 5.0: No More Callbacks! Previous Topic   Next Topic Topic: Unpicking the Microsoft Roadmap


Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2014 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us