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 advantages of using stored procedures?

544


What the different topologies in which replication can be configured?

560


What are system databases into sql server (2005/2008) : sql server database administration

575


Which database stores information about replication?

559


What is a raid and what are different types of raid configurations?

634






What does normalization do to data?

550


What are date and time data types in ms sql server?

531


How can you stop stored procedures from recompiling?

492


Can we insert data if clustered index is disabled?

511


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

654


Define right outer join in sql server joins?

521


How to backup SQL Server Reporting Services ?

103


What is the recommended total size of your memory optimized tables?

532


When multiple after triggers are attached to sql table, how to control the order of execution?

535


Explain the difference between HTTP and HTTPS in database?

564