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 the new scripting capabilities of ssms? : sql server management studio

1001


role of sql sever 2005 in database rather than any other database

1887


What do you understand by user-defined function in the sql server?

901


Distinguish between nested subquery and correlated subquery?

973


What is the order in which the sql query is executed?

880


What are parameterized reports?

191


What are security principals used in sql server 2005?

905


What are the new data types are introduced in sql 2000?

859


Explain what is meant by replication of database?

956


Does the order of columns in update statements matter?

858


What will be the maximum number of indexes per table?

908


What are the types of user defined functions in sql server?

989


Explain time data type in sal server 2008?

870


Explain tables in SQL Azure?

120


How to connect ms access to sql servers through odbc?

970