Answer Posted / selvaraj.v

In SQL Server 2000,

Query :
-------

create table BookDetails
(
Book_ID int identity(1,1) not null primary key,
Book_Title varchar(20),
Book_Type varchar(15),
Book_Author varchar(25),
Book_Edition float,
Book_Publisher varchar(20),
Book_Pub_Year datetime,
Book_Price int primary key
)

Answer :
--------

Server: Msg 8110, Level 16, State 1, Line 1
Cannot add multiple PRIMARY KEY constraints to
table 'BookDetails'.

Reply Answer:
-------------
So,Can't Create more Primary Keys in a Table.

What is normalization process?

1109

---

What do you understand by check constraint in sql server?

889

---

Can we use custom code in ssrs?

1060

---

What is the difference between lock, block and deadlock? : sql server database administration

992

---

how to invoke a trigger on demand? : Sql server database administration

1002

---

Does partitioning ssd reduce performance?

849

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1327

---

What are the kinds of subquery?

951

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

981

---

what's sql server? : Sql server database administration

931

---

What does indexation mean?

916

---

Explain having clause and where clause?

991

---

what are user defined datatypes? : Sql server database administration

924

---

How column data types are determined in a view?

901

---

What are window functions in sql server?

940

---