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

is there more the two primary key in a single table?

Answer Posted / navaneethakrishnan

no we cannot,

but we can do composite key in sql2005,

go in enterprise manager...

in the design view first set the primary key to one field
and then press ctrl key and set primary key to another field..

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many databases can we create in a single server?

209


What is the use of builtinadministrators group in sql server? : sql server security

1105


What is a collation in ms sql server?

1132


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

1036


What do you understand by recursive stored procedures?

1043


What is data source in connection string?

955


What are the steps to insert a table?

991


How to remove duplicate rows from table except one?

1061


What are secondary xml indexes?

1075


Write a SQL query to delete a table?

1184


What is the difference between nvl and nvl2?

1025


Where do we use trace frag?

1060


What is nonclustered index on computed columns?

995


What is join and name different type of joins?

1097


Create and insert into temp table in sql server?

1081