Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?
Answer Posted / 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 |
Post New Answer View All Answers
What is difference statement and preparedstatement?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Tell me about joins in database system and explain each in detail.
Explain about unique identifier data type in sql server?
Give an example of SQL injection attack ?
How do I know if localdb is running?
Mention the differences between having and where clause.
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Can you move the resources after pausing the node? : sql server database administration
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Explain an incremental backup?
What are different types of views?
When is update_statistics command used?