I have a table with 15 columns (I may NOT know the number of columns) in SQL Server 2000 database. I want to find the data for the first 5 columns (let us say). I DO NOT want the rest of the column's data. Please remember that we must do this within a single SQL Statement (No more multiple statements)!! Can you please provide me the single SQL Statement for doing this ?
Appreciate your time, patience and help !!