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

What is code near application topology?

250


What is the need for indexing?

718


List few advantages of stored procedure.

770


What does sql server mean?

752


What is normalization? Describe its different types.

855


What is the difference between join and inner join?

788


What are the properties of sub-query?

838


What are recommended options to be used while using db mirroring? : sql server database administration

838


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

703


What is difference between rollback immediate and with no_wait during alter database?

847


What happens if you add a new index to large table?

718


What is an indexing strategy?

754


What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

838


How to automatically create a log when an exception is being received into SQL Server?

989


What is explicit cursors?

784