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
What is code near application topology?
What is the need for indexing?
List few advantages of stored procedure.
What does sql server mean?
What is normalization? Describe its different types.
What is the difference between join and inner join?
What are the properties of sub-query?
What are recommended options to be used while using db mirroring? : sql server database administration
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is difference between rollback immediate and with no_wait during alter database?
What happens if you add a new index to large table?
What is an indexing strategy?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How to automatically create a log when an exception is being received into SQL Server?
What is explicit cursors?