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

How can I get data from a database on another server?

997


What is the largest component inside a field?

1128


What is an identity column in insert statements?

1023


How do I create a stored procedure in dbml?

1009


Explain an incremental backup?

1003


Write the queries for commands like Create Table, Delete table, Drop Table etc.

1114


Mention what are the core components of ssrs?

323


When to use null data driven subscription?

207


Do you know what is lock escalation?

1013


What is the difference between clustered index and primary key?

922


Explain what is meant by replication of database?

1033


How to generate create procedure script on an existing stored procedure?

1011


1 01 101 01010

2055


How to rename an existing column with sql server management studio?

999


What Are the Main Features of SQL Azure?

117