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 Federation Root Database?
What is Federation and Federation Member?
What is the optimization being performed in oracle and SQL Server?
How to connect Azure federated root database and apply federation in entity framework?
What is a system database and what is a user database?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is TDS(Tabular Data Stream) Gateway?
How to transfer a table from one schema to another?
Give me a SQL Query to find out the second largest company?
How can I check that whether automatic statistic update is enabled or not?
What are the differences between web role and worker role?
can an order by clause be used in a creation of a view?
What do you mean by the term 'normalization'?
What is default constraint?
What do you understand by hotfixes and patches in sql server?