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

Answer Posted / ricky

in sql server 2000 we can create the uniqe and primary key
constraint in computeted coloumn.....but in sql server 2005
we can not create the uniqe and primery constraints in
computed coloumn.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the service pack installed? : sql server database administration

554


How to use column default values in insert statements in ms sql server?

532


Explain hostprotectionattribute in sql server 2005?

602


Can you explain full-text query in sql server?

554


How to change the data type of an existing column with "alter table" statements in ms sql server?

534






What do you mean by data manipulation language?

597


How to find index size for each index on table?

587


Why is sql server log file full?

540


Explain syntax for disabling triggers?

526


How to create a stored procedure with a statement block in ms sql server?

578


What are the options which must be set to allow the usage of optimistic models?

521


What is NOT NULL Constraint in sql server 2012?

605


How to convert binary strings into integers in ms sql server?

559


What is provisioning, billing and metering, and connection routing concepts in the service layer?

94


Explain the cursor lock types?

557