August 27, 2008 at 5:16 am
How do i display all the values in all 23 available columns of a table t1 when i don't know the number of rows available.
August 27, 2008 at 5:26 am
Select * from table1
August 27, 2008 at 5:27 am
Chandu (8/27/2008)
How do i display all the values in all 23 available columns of a table t1 when i don't know the number of rows available.
This should do the trick:
SELECT * FROM t1
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
August 27, 2008 at 5:27 am
Maybe I have misunderstood. But wouldn't select * from T1 do the trick. Not that you should use select * but maybe I have misunderstood the post.
August 27, 2008 at 7:18 am
Exscellent.. Selcet * from t1 has worked.. Thanks to all for working out on the query.
August 27, 2008 at 7:23 am
Chandu (8/27/2008)
Exscellent.. Selcet * from t1 has worked.. Thanks to all for working out on the query.
Gald to be of assitsance, Chnadu!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply