Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find number of columns in a table in sql server 2000
and 2005 also

Answer Posted / mohan

Guys.. Why don;t you try for the Columns bided with User
Defined Data Type and try the above queries... and Also try
for the Auto incremented Columns..(Identity)....
Your opinion would change definately....
Try out...
I am sure it doesn't take account of UDT Binded Coulmns

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are unicode character string data types in ms sql server?

1241


Can I disable or restrict ssrs export formats (rendering formats)?

150


What do we need queues in sql service broker?

1061


Give an example of why you would want to denormalize a database

972


What is difference between line feed ( ) and carriage return ( )?

896


What is the use of toad or sqldbx.?

1144


How to create sub reports?

242


Tell me in brief how sql server enhances scalability of the database system?

982


What are the advantages of stored procedure in sql server?

887


What is code near application topology?

279


What is the difference between row_number and dense_rank?

872


What is the sql server agent?

1080


What method is used by the Command classes to execute SQL statements that return single values?

1057


What is transaction server distributed transaction?

1046


When cursors are useful?

1091