Because SQL Server 2000 supports indexes on computed columns, you can cre

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

Question Posted / uma lakshman

Answer Posted / uma lakshman

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

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a database table?

924

How you would rewrite the sql query to return the customerid sorted numerically?

936

What are the different types of collation sensitivity?

1055

How to generate create function script on an existing function?

1044

Do you know what is rank function?

1028

What is the difference between varchar and varchar(max) datatypes?

1002

How many tables can be joined in SQL Server?

1004

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

897

Can you type more than one query in the query editor screen at the same time?

953

What is the cartesian product of table?

929

Explain features and concepts of analysis services?

930

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

936

can an order by clause be used in a creation of a view?

1099

How to list all user defined functions in the current database?

975

Explain active/passive and active/active cluster configurations?

1014