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 / debi

1.no we can't set more than one primary key for a table
3. yes we can write a query like select 8 from table1,table2
this is generally used in case of cartesian product

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

843


How many types of functions are there in sql server?

874


How do I perform an unattended install of sql server 2000?

1018


Explain the architecture of ms sql reporting service?

872


List down some advantages of sql stored procedure?

902


How connect excel to sql server?

928


What is dirty read?

1041


Do you know what is fill factor and pad index?

940


How will you find out if there are expensive SQL statements running or not?

965


What is sql server database?

935


What do you understand by mirroring?

951


What are parameterized reports?

191


How to create an index on a view?

986


What is the security model used in sql server 2005?

934


what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

947