|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 24th, 2002, 06:43 PM
|
|||
|
|||
|
help in Sql query
<i><b>Originally posted by : sesh (Seshagiri_Rao@reyrey.com)</b></i><br />Hi,<br /> i need to find out the number of columns in a table(column count). can anyone help me out<br />
|
|
#2
July 24th, 2002, 07:03 PM
|
|||
|
|||
|
<i><b>Originally posted by : sesh (Seshagiri_Rao@reyrey.com)</b></i><br />adding to my previous question query must be accessed by MsAcess or SqlServer<br /><br /><br />------------<br />sesh at 7/24/2002 3:43:18 PM<br /><br />Hi,<br /> i need to find out the number of columns in a table(column count). can anyone help me out<br />
|
|
#3
October 14th, 2003, 12:07 PM
|
|||
|
|||
|
Access:
open a recordset and use the fields collection: rs.Fields.Count - 1 (0-based) SQLServer: select count(*) from sysobjects o, syscolumns c where o.id = c.id and o.name = 'MyTable'
|
|
| Viewing: ASP Free Forums > Database > SQL Development > help in Sql query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
