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

None of the above answer can result the columns which is
having auto incremented (Identity).
Also if a column is binded to user defined data type that
is also excluded....
So the Correct Number of column cannot be resulted in the
above answers.........

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is indexed view? How to create it?

930


Write a SQL queries on Self Join and Inner Join.

984


What is the sql case statement used for? Explain with an example?

937


Explain system scalar functions?

951


What is use of attributehierarchyenabled? : sql server analysis services, ssas

1160


What is the default Port No on which SQL Server listens?

1067


do views contain data ?

911


Why do we use sql limitations? Which constraints can we use while making a database in sql?

1001


Explain the database you used in your final year project?

969


Explain filtered indexes?

931


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

958


What are the new features in sql server 2016?

928


What is logshipping and its purpose?

943


What is normalization of database?

1019


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

967