is there more the two primary key in a single table?
Answer Posted / asas
NO guys
create table prk(eno int primary key, dno int primary key)
Msg 8110, Level 16, State 0, Line 1
Cannot add multiple PRIMARY KEY constraints to table 'prk'.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the types of ssrs?
Explain microsoft sql server functions?
How do I view a procedure in sql server?
wat wil hapn if we give the both read and deny read permission to user?
Explain the difference between primary keys and foreign keys?
what is a transaction? : Sql server database administration
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is table join?
What is delete query?
Why can there be only one clustered index and not more than one?
What is the default sql server instance name?
What is a constant or literal in ms sql server?
Explain indexing and what are the advantages of it?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How to loop through returning rows?