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
How to find the service pack installed? : sql server database administration
How to use column default values in insert statements in ms sql server?
Explain hostprotectionattribute in sql server 2005?
Can you explain full-text query in sql server?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What do you mean by data manipulation language?
How to find index size for each index on table?
Why is sql server log file full?
Explain syntax for disabling triggers?
How to create a stored procedure with a statement block in ms sql server?
What are the options which must be set to allow the usage of optimistic models?
What is NOT NULL Constraint in sql server 2012?
How to convert binary strings into integers in ms sql server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Explain the cursor lock types?