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
How many databases can we create in a single server?
What is the use of builtinadministrators group in sql server? : sql server security
What is a collation in ms sql server?
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?
What do you understand by recursive stored procedures?
What is data source in connection string?
What are the steps to insert a table?
How to remove duplicate rows from table except one?
What are secondary xml indexes?
Write a SQL query to delete a table?
What is the difference between nvl and nvl2?
Where do we use trace frag?
What is nonclustered index on computed columns?
What is join and name different type of joins?
Create and insert into temp table in sql server?