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

How do you create an execution plan?

937

Define primary key?

1123

What is default constraint?

989

What protocol does sql server use?

931

Why can there be only one clustered index and not more than one?

995

What is function of CUBE ?

1030

how would you store your query in an SSRS report or a Database server?

162

How to change parameter value inside the report?

164

Explain the commands in sql server?

1029

Can group by be used without aggregate functions?

910

Can we use where clause with group by?

891

What is SubQuery in SQL Server 2008

1015

What do you understand by hotfixes and patches in sql server?

972

Where are stored procedures in sql server?

1057

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

986