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 is the purpose of sql profiler in sql server?

691


What is primary key and example?

690


What are the operating modes in which database mirroring runs?

799


What is perspective, have you ever created perspective? : sql server analysis services, ssas

663


How we can refresh the view?

785






What is temporal table?

626


What is the correct order of the logical query processing phases?

679


How to update values in a table with update statements in ms sql server?

723


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1739


What is optimization and its types?

695


What is set nocount on and what is set nocount off?

661


What is database replication? What are the different types of replication you can set up in sql server?

658


How to set database to be read_only in ms sql server?

711


How to start sql server browser service?

757


between cast and convert which function would you prefer and why?

719