Interested to Buy Any Domain ? << Click Here >> for more details...
Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?
- 3 Answers
- 10378 Views
- Infosys, I also Faced
- E-Mail Answers
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 are the types of lock supported by ?
What are the five major components of a dbms?
how will add additional conditions in sql?
What is a select query statement in ms sql server?
What is the purpose of the master database?
Explain linked server in sql?
What are the different authentication modes in sql server? How can it be changed?
What is serializable?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How do you create a data source?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What are the properties of the relational tables?
Why use “in” clause in sql server?
What is the process of normalising?
