Finding the data of first 'n' columns in SQL Server 2000 !!


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 !!

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!