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: 2281

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