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
- 10525 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kirubaharan
Unable to create index 'PK'.
Cannot define PRIMARY KEY constraint on Computed column in
table.
Could not create constraint. See previous errors.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / uma lakshman
Because SQL Server 2000 supports indexes on computed
columns, you can create UNIQUE and PRIMARY KEY constraints
on computed columns
| Is This Answer Correct ? | 3 Yes | 2 No |
What is the difference between count and distinct count?
What are the benefits of normalization?
How are SQL Server databases physically stored under Windows 2000?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are the advantages of having an index on the sql server?
What is #temp and @table variable in SQL server?
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;
What is an Index?
What are the disadvantages of primary key and foreign key in SQL?
What are the types of indexing?
What is the difference between ‘having’ clause and a ‘where’ clause?
Do you know query execution plan?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
