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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of database recovery models?

822


How to create an inline table-valued function?

753


Can we do dml on views?

759


What is the difference between TRUNCATE and DROP?

832


Does server sql treat char as a variable-length or fixed-length column?

802


How to generate create function script on an existing function?

823


How does Report Builder support Analysis Services cubes?

136


Explain boyce and codd normal form(bcnf)?

734


What is the difference between Normalization and De-normalization?

818


what are the important architecture components of SSRS?

112


How check triggers in sql server?

703


can you implement data mining in SSRS?

127


What is Lock table in SQL?

1227


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.

1778


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1633