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.

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2111

---

What are the hotfixes and patches in sql server?

1062

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

1090

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

---

What is hot add cpu in sql server 2008?

982

---

How to locate and take substrings with charindex() and substring() functions?

1071

---

What will happen if a column containing char type data is changed to the nchar data type?

1149

---

What happens if you are trying to access a schema not owned by you?

1020

---

What is transaction server explicit transaction?

1087

---

Do you know the isolation level that sql server support?

1001

---

Explain external key management in sql server 2008

934

---

If no size is defined while creating the database, what size will the database have?

1034

---

How to view existing indexes on an given table using sp_help?

1204

---

how will add additional conditions in sql?

1169

---

What is table level trigger?

1054

---