diffrence between * and select coumn name in sqlserver

Question

hi all Please Tell me diffrence between select * from FT_MOVEMENT_DETAIL and select FICN_ACCUSED_DETAILFICN_ACT_SECTIONFICN_DETAIL from FT_MOVEMENT_DETAIL which query execute fast and why ?

Priyaranjan K S · Answer

Hi Rajveer Selecting only relevant columns doesn’t improve the performance of query processing; however there is an overall performance improvement to the system. For example when you select only relevant column(s) from a table the amount of data transferred from database server to frontend server will be less and data get transferred quickly. You may refer here for more detailed explanation : http://discoversql.blogspot.com/2012/04/select-vs-select-columns-sql-server.html Thanks Priyan If you found this useful Please mark this as Answer

chaitanya pathak · Answer

1 . SELECT * FROM tblName : which will returns the all the list of column present in your table 2.SELECT Col1Col2Col3: Which will returns only specific column which you mentioned in your select list EX . tblLogin UserName Password 1000 1000 1. SELECT * FROM tblLogin : gives the EntireList of Column 2. SELECT UserName from tblLogin : gives the only UserName 1000

Raja T · Answer

Hi Rajveer Checkout bellow URL http://gertjans.home.xs4all.nl/sql/dont-use-select-star-in-production-code.html

N Vinodh · Answer

Dear Rajveer singh Using select * you can retrive all the values from the table can't able to get the particular column or row Using select columnname from table using this you can able to fetch the records from the particular column and row Please mark if accepted as a answer' Regards Vinodh.N (sharepoint developer/Administrator)