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 are logical/boolean operations in ms sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What are the different types of Indexes available in SQL Server?
What is oltp (online transaction processing)?
What is msdb database? : SQL Server Architecture
Explain full-text indexing?
Which are the important points to note when multilanguage data is stored in a table?
Does union all remove duplicates?
How do you Implement SSIS Packages in your Project?
What is RAID? What are the different types of RAID configurations?
Explain cursor as data base object?
What are cascading parameters in ssrs reports?
How will you monitor replication latency in transactional replication? : sql server replication
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
why would you use sql agent? : Sql server database administration