select columns

• esqared7

  SSC Veteran

  Points: 251

  More actions

  March 10, 2003 at 10:21 pm

  #81712

  Is there a way to find out how many parameters/columns one has selected from a select query

  example

  select name,id from Customers-- has 2 parameters

  select name,desc,id from customers -- has 3 paramaters

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 11, 2003 at 4:14 am

  #450769

  To the best of my knowledge I have not come across sql function to do so.

  What specifically is your goal however as there may be some option I have not thought of to reach the goal.

• luanjubica

  SSC-Addicted

  Points: 408

  More actions

  March 13, 2003 at 8:17 am

  #450993

  You can use ADO recordset to do so (if ADO is in your framework) ! I don't know any Transact-SQL function having this scope!

  Luani

  
  Luani