Answer / kirubaharan

Unable to create index 'PK'.
Cannot define PRIMARY KEY constraint on Computed column in
table.
Could not create constraint. See previous errors.

Answer / ricky

in sql server 2000 we can create the uniqe and primary key
constraint in computeted coloumn.....but in sql server 2005
we can not create the uniqe and primery constraints in
computed coloumn.

Answer / uma lakshman

Because SQL Server 2000 supports indexes on computed
columns, you can create UNIQUE and PRIMARY KEY constraints
on computed columns

What is public role in sql server?

0 Answers  

---

What is self contained sub query?

0 Answers  

---

What is compound operators?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

When we should use and scope of @@identity?

0 Answers  

---

What is a primary key?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

Explain sub-query?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

---

What is the use of DBCC commands?

4 Answers   NA,

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---