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...

1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;"

Answer Posted / anilreddy

1)No,but in single primary key we can select upto 16 columns
2)Clustered index can be only one,Nonclustered indexes can be 249
3)Yes,we can write cross join will be applied

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

935


what are the critical issues you have resloved in your company

1965


Explain concepts of analysis services?

967


If user is owning any SQL Objects, can we drop that user

2083


how many triggers you can have on a table? : Sql server database administration

984


How do I port a number to sql server?

1046


How column data types are determined in a view?

967


How and why use sql server?

1017


What do you understand by the data quality services in sql server?

953


Tell me extended events in sql server 2008?

1001


What are the key configuration files for sql server reporting services ?

170


List some case manipulation functions in sql?

1039


What is the recovery model?

995


what's sql server? : Sql server database administration

1003


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

992