I have a table with 10 columns. I need to display name column as textfield and Id column as value field in the drop down.

Write the best possible query to get the records.

 Posted by Virendradugar on 12/31/2009 | Category: Sql Server Interview questions | Views: 2352
Answer:

The best query is

Select ID,Name from Table1


Don't use

Select * from Table1


As it creates an extra overhead and reduces performance. Always fetch only those column which are needed to get better performance.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response