in sql server 2000 we can create the uniqe and primary key constraint in

Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?

Question Posted / ricky

3 Answers
10323 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / 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.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is create command?

962

Explain activity monitors

1062

Explain transaction server explicit transaction?

923

Where to find ntwdblib.dll version 2000.80.194.0?

954

How to change the ownership of a schema in ms sql server?

1172

How to find the list of fixed hard drive and free space on server?

1175

What do you understand by recursive stored procedure?

916

Explain the properties of sub-query in sql server?

1000

Can foreign key be duplicate?

1044

How to achieve Paging of records in SQL SERVER?

1089

1 01 101 01010

2041

What is dbcc?

1127

How many categories of functions based their return modes?

1095

Can you force a query to use a specific index?

930

What is data source object?

988