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 / ashutosh jha

select count (*) from tablename.

Is This Answer Correct ?    7 Yes 134 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are acid properties of transaction?

894


How you trouble shoot when any job fails

1894


What is difference between views and tables?

913


What are the security related catalog views? : sql server security

913


In which sql server version report builder introduced?

142


How network traffic be reduced by using the stored procedure?

1045


explain declarative management framework (dmf) in sql server 2008?

949


Explain about builtinadministrator?

986


What does it mean to manipulate data?

943


What will be query used to get the list of triggers in a database?

954


Explain isolation levels that sql server supports?

986


how to create “alternate row colour”?

142


Mention the uses of stored procedures.

927


Please explain go command in sql server?

991


How to delete existing triggers using "drop trigger"?

990